{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["USER GUIDE","1. ASSESSMENT PROFILE","2. SUMMARY AND ANALYSIS","3. TABLE SUMMARIES","4. DATA QUALITY ANALYSIS","5a. PRESUMPTIVE REGISTER - AGG","5b. PRESUMPTIVE REGISTER -  PL","6a. LAB REGISTER - AGG","6b. LAB REGISTER - PL","7a. TB TX REGISTER - AGG","7b. TB TX REGISTER - PL","8a. TPT REGISTER - AGG","8b. TPT REGISTER - PL","Hidden Formula"],"not_rendered":{"charts":12,"images":2,"macros":1,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"USER GUIDE","index":0,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[[15,3,15,15],[31,1,31,3],[8,1,8,15],[5,1,5,15],[14,3,14,15],[17,3,17,15],[16,3,16,15],[18,3,21,15],[22,3,25,15],[27,4,29,15]]}
[]
[]
[null,null,"Diagnostic Cascade Evaluation (DiCE) Toolkit: User Guide"]
[]
[null,"INTRODUCTION"]
[null,"The purpose of this toolkit is to identify points in the TB diagnostic cascade where failures in clinic-lab interface may prevent the initiation of TB treatment in individuals with active TB disease. The diagnostic cascade refers to a step-wise process that spans the initial presentation of an individual with presumptive TB to the ultimate initiation of TB treatment, and encompasses all intermediate steps. This toolkit is designed as a first step in procedural improvement and should be followed with planned conversation and development of action plans with implementing partners. The intended targets for these activities are sites supported by the President's Emergency Plan for AIDS Relief (PEPFAR)."]
[]
[null,"USING THE TOOL"]
[null,"Colored tabs are intended for data entry from registers where patient information is recorded along the diagnostic cascade. The user will need to visit multiple locations including, at a minimum, the facility where TB screening occurred (HIV Clinic or TB Clinic) and the laboratory responsible for TB diagnostic testing. Aggregate-level data and patient-level data should be abstracted in tandem since data source are the same. Personally identifying information such as patient name should not be collected. Registers will be required at each location and partners on site should be notified of user needs prior to arrival. The \"SUMMARY AND ANALYSIS\" tab is designed to compile results of this exercise in a way that will highlight areas of patient drop-off. This tab will also allow a user to assess the amount of time between each step in the diagnostic cascade for a sample of patients. Analyses will be automatically populated using the data entered in colored tabs. "]
[null,"FILTERING VIEWABLE TABS"]
[null,"For ease of viewing, tab selections can be made below: "]
[null,"ALL","\u0080"]
[]
[null,"CONTENTS"]
[null,"1. ASSESSMENT PROFILE",null,"This tab is intended to document the time, place, and participants involved in this activity. The user should also select the type of assessment here (entry/exit). "]
[null,"2. SUMMARY AND ANALYSIS",null,"This tab is intended to highlight the findings from aggregate- and patient-level data entry on the TB cascade steps and demographic information on patients with presumptive TB; all values will be auto-populated from colored data entry tabs (5-7).  Key time intervals are also calculated, which are intended to display the time period between steps in the diagnostic cascade; this will be auto-populated from patient-level data entered in tabs 5b-7b. Finally, data entered on TPT in tab 8a will be summarized here. "]
[null,"3. TABLE SUMMARIES",null,"Data entered in tabs 5-8 will be summarized in table format here. "]
[null,"4. DATA QUALITY ANALYSIS",null,"This tab is intended to compare patient-level data elements that appear in multiple sources for concordance. This can be useful in ensuring the same individual was traced through all data sources; it can also help highlight weaknesses in recording practices if many inconsistent entries are observed. "]
[null,"5a. PRESUMPTIVE REGISTER - AGG",null,"These tabs are the \"Agg\" or aggregate data collection tabs. The tables are built to assist in data abstraction at the aggregate level by counting page totals for each field. Each row will represent sums from one page of a register; sections are provided for each time period. "]
[null,"6a. LAB REGISTER - AGG"]
[null,"7a. TB TX REGISTER - AGG"]
[null,"8a. TPT REGISTER - AGG"]
[null,"5b. PRESUMPTIVE REGISTER - PL",null,"These tabs are the \"PL\" or patient-level data entry tabs. The user will select a random sample of presumptive TB from the register who were entered in the specified time period, half HIV+ and half HIV-, using the sampling approach below. Using common identifiers, the user will then complete all fields using various data sources along the diagnostic pathway. Data entry will be one patient per column; all dates should be entered in format dd-Mmm-yy (ex. 30-Mar-19) . A section for notes is provided below each section in the event of abnormal findings that do not fit tool parameters. \n\nSampling Approach for Patient-Level Data Collection\n1. Calculate 5% of total individuals with presumptive TB found in the Presumptive TB Register, with a minimum of 6 and a maximum of 20. Select half HIV+ individuals and half HIV- individuals (ex. 400 presumptive TBs = sample of 20; 10 HIV+, 10 HIV-).\n2. To ensure random selection, ensure that selections are made from different pages of the register and different months. Selections should be made independent of data quality or completion. "]
[null,"6b. LAB REGISTER - PL"]
[null,"7b. TB TX REGISTER - PL"]
[null,"8b. TPT REGISTER - PL"]
[]
[null,null,null,null,"DISCLAIMER:\nThe design and construction, and thus the findings and conclusions obtained from the use, of this software tool is the responsibility of the user(s) and does not necessarily represent the official position of the U.S. Centers for Disease Control and Prevention."]
[]
[]
[null,"Updated February 14, 2022"]
[null,"Designed by Jamie Dawson (CDC/CGH/DGHT/ILB)\nand Meaghan Peterson (CDC/CGH/DGHT/GTB)"]
[null,"Contact: kuk7@cdc.gov"]

{"sheet":"1. ASSESSMENT PROFILE","index":1,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,1,33,2],[33,3,33,9],[15,2,15,4],[14,2,14,4],[15,5,15,7],[20,1,20,5],[19,3,19,8],[19,1,19,2],[17,5,17,6],[17,7,17,8],[17,1,17,2],[17,3,17,4],[18,5,18,6],[18,7,18,8],[18,1,18,2],[18,3,18,4],[29,1,29,2],[30,1,30,2],[31,1,31,2],[29,3,29,9],[30,3,30,9],[31,3,31,9],[27,1,27,2],[26,5,26,6],[23,1,23,2],[25,1,25,2],[25,3,25,4],[25,5,25,6],[27,3,27,9],[14,5,14,7],[21,1,21,2],[21,3,21,4],[26,3,26,4],[22,3,22,4],[22,7,22,9],[23,3,23,9],[25,7,25,9],[26,7,26,9],[22,1,22,2],[26,1,26,2],[21,5,21,6],[21,7,21,8],[22,5,22,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Type of Assessment: ",null,null,"Exit"]
[null,null,"Date of Data Collection:"]
[]
[null,"HIV Facility\n Name",null,null,null,"Facility POC \nName"]
[null,"Facility POC\n Email",null,null,null,"Facility POC\n Number"]
[null,"Location Address:"]
[]
[null,"TB Facility \nName",null,null,null,"Facility POC \nName"]
[null,"Facility POC \nEmail",null,null,null,"Facility POC \nNumber"]
[null,"Location Address:"]
[]
[null,"Laboratory \nName",null,null,null,"Facility POC \nName"]
[null,"Facility POC \nEmail",null,null,null,"Facility POC \nNumber"]
[null,"Location Address:"]
[]
[null,"Name of Collector #1"]
[null,"Name of Collector #2"]
[null,"Name of Collector #3"]
[]
[null,"Additional Participants: "]

{"sheet":"2. SUMMARY AND ANALYSIS","index":2,"n_rows":160,"n_cols":19,"rows_kept":160,"cut":false,"hidden":false,"merged":[[150,8,150,9],[151,8,151,9],[145,8,145,9],[146,8,146,9],[147,8,147,9],[148,8,148,9],[149,8,149,9],[82,7,82,9],[83,7,83,9],[76,7,76,9],[77,7,77,9],[78,7,78,9],[79,7,79,9],[80,7,80,9],[81,7,81,9],[108,7,108,10],[109,7,109,10],[101,7,101,10],[102,7,102,10],[103,7,103,10],[104,7,104,10],[105,7,105,10],[106,7,106,10],[107,7,107,10]]}
[null,"AGGREGATE-LEVEL ANALYSIS"]
[]
[null,"Steps","Period 1","Period 2","Period 3","Total"]
[null,"1. Presumptive TB",{"$f":"AggPresumptiveP1[[#Totals],[Total Presumptive TB]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[Total Presumptive TB]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[Total Presumptive TB]]","v":0},{"$f":"SUM(C4:E4)","v":0}]
[null,"2. Specimen collected",{"$f":"AggPresumptiveP1[[#Totals],[Number Specimens Collected]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[Number Specimens Collected]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[Number Specimens Collected]]","v":0},{"$f":"SUM(C5:E5)","v":0}]
[null,"3. Specimen received by lab",{"$f":"AggLabP1[[#Totals],[Total Specimens]]","v":0},{"$f":"AggLabP2[[#Totals],[Total Specimens]]","v":0},{"$f":"AggLabP3[[#Totals],[Total Specimens]]","v":0},0]
[null,"4. Specimen tested (AFB/NAAT)",{"$f":"SUM(AggLabP1[[#Totals],[AFB (-)]:[Inavlid\nNo Result Error\n(I)]])","v":0},{"$f":"SUM(AggLabP2[[#Totals],[AFB (-)]:[Inavlid\nNo Result Error\n(I)]])","v":0},{"$f":"SUM(AggLabP3[[#Totals],[AFB (-)]:[Inavlid\nNo Result Error\n(I)]])","v":0},0]
[null,"5. NAAT result in lab",{"$f":"SUM(AggLabP1[[#Totals],[MTB Not Detected\n(N)]:[Inavlid\nNo Result Error\n(I)]])","v":0},{"$f":"SUM(AggLabP2[[#Totals],[MTB Not Detected\n(N)]:[Inavlid\nNo Result Error\n(I)]])","v":0},{"$f":"SUM(AggLabP3[[#Totals],[MTB Not Detected\n(N)]:[Inavlid\nNo Result Error\n(I)]])","v":0},0]
[null,"6. NAAT (+) result in lab",{"$f":"SUM(AggLabP1[[#Totals],[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)]:[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)]])","v":0},{"$f":"SUM(AggLabP2[[#Totals],[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)]:[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)]])","v":0},{"$f":"SUM(AggLabP3[[#Totals],[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)]:[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)]])","v":0},{"$f":"SUM(C9:E9)","v":0}]
[null,"7. Positive LAM result in lab",{"$f":"AggLabP1[[#Totals],[LAM Positive]]","v":0},{"$f":"AggLabP2[[#Totals],[LAM Positive]]","v":0},{"$f":"AggLabP3[[#Totals],[LAM Positive]]","v":0},{"$f":"SUM(C10:E10)","v":0}]
[null,"8. NAAT (+) result in clinic",{"$f":"SUM(AggPresumptiveP1[[#Totals],[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)]:[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)]])","v":0},{"$f":"SUM(AggPresumptiveP2[[#Totals],[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)]:[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)]])","v":0},{"$f":"SUM(AggPresumptiveP3[[#Totals],[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)]:[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)]])","v":0},{"$f":"SUM(C11:E11)","v":0}]
[null,"9. Positive LAM result in clinic",{"$f":"AggPresumptiveP1[[#Totals],[LAM Positive]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[LAM Positive]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[LAM Positive]]","v":0},{"$f":"SUM(C12:E12)","v":0}]
[null,"10. Patients initiating TB treatment",{"$f":"AggTreatmentP1[[#Totals],[Total Patients ]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Total Patients ]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Total Patients ]]","v":0},{"$f":"SUM(C13:E13)","v":0}]
[null,"11. Patients cured or completing TB treatment",{"$f":"SUM(AggTreatmentP1[[#Totals],[Cured\n(C)]:[ Completed\nTreatment\n(CTD)]])","v":0},{"$f":"SUM(AggTreatmentP2[[#Totals],[Cured\n(C)]:[ Completed\nTreatment\n(CTD)]])","v":0},{"$f":"SUM(AggTreatmentP3[[#Totals],[Cured\n(C)]:[ Completed\nTreatment\n(CTD)]])","v":0},{"$f":"SUM(C14:E14)","v":0}]
[]
[]
[null,"PATIENT-LEVEL ANALYSIS"]
[]
[null,"Steps","Total"]
[null,"1. Individuals with Presumptive TB Selected",{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!D9","v":0}]
[null,"2. Specimen Collection Documented",{"$f":"COUNTIFS(PLPresumptive[Specimen Collection Documented],\"Yes\")","v":0}]
[null,"3. NAAT sample sent to lab",{"$f":"PLPresumptive[[#Totals],[Date Specimen was Sent to Lab*]]","v":0}]
[null,"4. Specimens received by lab",{"$f":"COUNTIFS(PLLab[Available in Lab Register?],\"Yes\")","v":0}]
[null,"5. Specimens tested in lab (NAAT), excluding errors ",{"$f":"COUNTIFS(PLLab[Xpert MTB Result],\"MTB Detected\")+COUNTIFS(PLLab[Xpert MTB Result],\"MTB Not Detected\")","v":0}]
[null,"6. NAAT (+) in lab ",{"$f":"COUNTIFS(PLLab[Xpert MTB Result],\"MTB Detected\")","v":0}]
[null,"7. Positive LAM result in lab",{"$f":"COUNTIFS(PLLab[LAM Result], \"LAM Positive\")","v":0}]
[null,"8. NAAT (+) in clinic",{"$f":"COUNTIFS(PLPresumptive[Xpert MTB Result],\"MTB Detected\")","v":0}]
[null,"9. Positive LAM result in clinic",{"$f":"COUNTIFS(PLPresumptive[LAM Result], \"LAM Positive\")","v":0}]
[null,"10. Patients initiating TB treatment",{"$f":"PLTreatment[[#Totals],[Date Treatment Started*]]","v":0}]
[null,"11. Patients with a treatment outcome recorded",{"$f":"(COUNTA(PLTreatment[Treatment Outcome]))","v":0}]
[null,"12. Patients cured or completing TB treatment ",{"$f":"COUNTIFS(PLTreatment[Treatment Outcome],\"Cured\")+COUNTIFS(PLTreatment[Treatment Outcome],\"Treatment Completed\")","v":0}]
[]
["top"]
[null,"TURNAROUND TIME ANALYSIS (PATIENT-LEVEL)"]
[]
[null,"*Patient-level sample size: ",{"$f":"PLPresumptive[[#Totals],[Specimen ID Number]]","v":0},null,null,null,null,null,null,null,null,null,null,"Patient","DIAGNOSIS\n(From date of specimen collection to date of NAAT result received by clinic)","LAB TURNAROUND\n(From date specimens received by lab to date of NAAT result released)","TREATMENT INITIATION\n(From date of specimen collection to date patients begin treatment)","SPECIMEN TRANSFER \n(From date of specimen collection to date specimen received by lab) ","TB TREATMENT \n(From date of treatment initiation to date of treatment outcome)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P1",{"$f":"IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!J14<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H14<>0), '5b. PRESUMPTIVE REGISTER -  PL'!J14-'5b. PRESUMPTIVE REGISTER -  PL'!H14, \"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I11<>0,'6b. LAB REGISTER - PL'!R11<>0),'6b. LAB REGISTER - PL'!R11-'6b. LAB REGISTER - PL'!I11,\"NA\")","v":"NA"},{"$f":"IF(AND('8b. TPT REGISTER - PL'!F8<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H14<>0),'8b. TPT REGISTER - PL'!F8-'5b. PRESUMPTIVE REGISTER -  PL'!H14,\"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I11<>0, '5b. PRESUMPTIVE REGISTER -  PL'!H14<>0),'6b. LAB REGISTER - PL'!I11-'5b. PRESUMPTIVE REGISTER -  PL'!H14, \"NA\")","v":"NA"},{"$f":"IF(AND( '7b. TB TX REGISTER - PL'!Q9<>0,'7b. TB TX REGISTER - PL'!H9<>0), '7b. TB TX REGISTER - PL'!Q9-'7b. TB TX REGISTER - PL'!H9, \"NA\")","v":"NA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P2",{"$f":"IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!J15<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H15<>0), '5b. PRESUMPTIVE REGISTER -  PL'!J15-'5b. PRESUMPTIVE REGISTER -  PL'!H15, \"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I12<>0,'6b. LAB REGISTER - PL'!R12<>0),'6b. LAB REGISTER - PL'!R12-'6b. LAB REGISTER - PL'!I12,\"NA\")","v":"NA"},{"$f":"IF(AND('8b. TPT REGISTER - PL'!F9<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H15<>0),'8b. TPT REGISTER - PL'!F9-'5b. PRESUMPTIVE REGISTER -  PL'!H15,\"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I12<>0, '5b. PRESUMPTIVE REGISTER -  PL'!H15<>0),'6b. LAB REGISTER - PL'!I12-'5b. PRESUMPTIVE REGISTER -  PL'!H15, \"NA\")","v":"NA"},{"$f":"IF(AND( '7b. TB TX REGISTER - PL'!Q10<>0,'7b. TB TX REGISTER - PL'!H10<>0), '7b. TB TX REGISTER - PL'!Q10-'7b. TB TX REGISTER - PL'!H10, \"NA\")","v":"NA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P3",{"$f":"IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!J16<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H16<>0), '5b. PRESUMPTIVE REGISTER -  PL'!J16-'5b. PRESUMPTIVE REGISTER -  PL'!H16, \"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I13<>0,'6b. LAB REGISTER - PL'!R13<>0),'6b. LAB REGISTER - PL'!R13-'6b. LAB REGISTER - PL'!I13,\"NA\")","v":"NA"},{"$f":"IF(AND('8b. TPT REGISTER - PL'!F10<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H16<>0),'8b. TPT REGISTER - PL'!F10-'5b. PRESUMPTIVE REGISTER -  PL'!H16,\"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I13<>0, '5b. PRESUMPTIVE REGISTER -  PL'!H16<>0),'6b. LAB REGISTER - PL'!I13-'5b. PRESUMPTIVE REGISTER -  PL'!H16, \"NA\")","v":"NA"},{"$f":"IF(AND( '7b. TB TX REGISTER - PL'!Q11<>0,'7b. TB TX REGISTER - PL'!H11<>0), '7b. TB TX REGISTER - PL'!Q11-'7b. TB TX REGISTER - PL'!H11, \"NA\")","v":"NA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P4",{"$f":"IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!J17<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H17<>0), '5b. PRESUMPTIVE REGISTER -  PL'!J17-'5b. PRESUMPTIVE REGISTER -  PL'!H17, \"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I14<>0,'6b. LAB REGISTER - PL'!R14<>0),'6b. LAB REGISTER - PL'!R14-'6b. LAB REGISTER - PL'!I14,\"NA\")","v":"NA"},{"$f":"IF(AND('8b. TPT REGISTER - PL'!F11<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H17<>0),'8b. TPT REGISTER - PL'!F11-'5b. PRESUMPTIVE REGISTER -  PL'!H17,\"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I14<>0, '5b. PRESUMPTIVE REGISTER -  PL'!H17<>0),'6b. LAB REGISTER - PL'!I14-'5b. PRESUMPTIVE REGISTER -  PL'!H17, \"NA\")","v":"NA"},{"$f":"IF(AND( '7b. TB TX REGISTER - PL'!Q12<>0,'7b. TB TX REGISTER - PL'!H12<>0), '7b. TB TX REGISTER - PL'!Q12-'7b. TB TX REGISTER - PL'!H12, \"NA\")","v":"NA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P5",{"$f":"IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!J18<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H18<>0), '5b. PRESUMPTIVE REGISTER -  PL'!J18-'5b. PRESUMPTIVE REGISTER -  PL'!H18, \"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I15<>0,'6b. LAB REGISTER - PL'!R15<>0),'6b. LAB REGISTER - PL'!R15-'6b. LAB REGISTER - PL'!I15,\"NA\")","v":"NA"},{"$f":"IF(AND('8b. TPT REGISTER - PL'!F12<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H18<>0),'8b. TPT REGISTER - PL'!F12-'5b. PRESUMPTIVE REGISTER -  PL'!H18,\"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I15<>0, '5b. PRESUMPTIVE REGISTER -  PL'!H18<>0),'6b. LAB REGISTER - PL'!I15-'5b. PRESUMPTIVE REGISTER -  PL'!H18, \"NA\")","v":"NA"},{"$f":"IF(AND( '7b. TB TX REGISTER - PL'!Q13<>0,'7b. TB TX REGISTER - PL'!H13<>0), '7b. TB TX REGISTER - PL'!Q13-'7b. TB TX REGISTER - PL'!H13, \"NA\")","v":"NA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P6",{"$f":"IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!J19<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H19<>0), '5b. PRESUMPTIVE REGISTER -  PL'!J19-'5b. PRESUMPTIVE REGISTER -  PL'!H19, \"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I16<>0,'6b. LAB REGISTER - PL'!R16<>0),'6b. LAB REGISTER - PL'!R16-'6b. LAB REGISTER - PL'!I16,\"NA\")","v":"NA"},{"$f":"IF(AND('8b. TPT REGISTER - PL'!F13<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H19<>0),'8b. TPT REGISTER - PL'!F13-'5b. PRESUMPTIVE REGISTER -  PL'!H19,\"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I16<>0, '5b. PRESUMPTIVE REGISTER -  PL'!H19<>0),'6b. LAB REGISTER - PL'!I16-'5b. PRESUMPTIVE REGISTER -  PL'!H19, \"NA\")","v":"NA"},{"$f":"IF(AND( '7b. TB TX REGISTER - PL'!Q14<>0,'7b. TB TX REGISTER - PL'!H14<>0), '7b. TB TX REGISTER - PL'!Q14-'7b. TB TX REGISTER - PL'!H14, \"NA\")","v":"NA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P7",{"$f":"IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!J20<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H20<>0), '5b. PRESUMPTIVE REGISTER -  PL'!J20-'5b. PRESUMPTIVE REGISTER -  PL'!H20, \"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I17<>0,'6b. LAB REGISTER - PL'!R17<>0),'6b. LAB REGISTER - PL'!R17-'6b. LAB REGISTER - PL'!I17,\"NA\")","v":"NA"},{"$f":"IF(AND('8b. TPT REGISTER - PL'!F14<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H20<>0),'8b. TPT REGISTER - PL'!F14-'5b. PRESUMPTIVE REGISTER -  PL'!H20,\"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I17<>0, '5b. PRESUMPTIVE REGISTER -  PL'!H20<>0),'6b. LAB REGISTER - PL'!I17-'5b. PRESUMPTIVE REGISTER -  PL'!H20, \"NA\")","v":"NA"},{"$f":"IF(AND( '7b. TB TX REGISTER - PL'!Q15<>0,'7b. TB TX REGISTER - PL'!H15<>0), '7b. TB TX REGISTER - PL'!Q15-'7b. TB TX REGISTER - PL'!H15, \"NA\")","v":"NA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P8",{"$f":"IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!J21<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H21<>0), '5b. PRESUMPTIVE REGISTER -  PL'!J21-'5b. PRESUMPTIVE REGISTER -  PL'!H21, \"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I18<>0,'6b. LAB REGISTER - PL'!R18<>0),'6b. LAB REGISTER - PL'!R18-'6b. LAB REGISTER - PL'!I18,\"NA\")","v":"NA"},{"$f":"IF(AND('8b. TPT REGISTER - PL'!F15<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H21<>0),'8b. TPT REGISTER - PL'!F15-'5b. PRESUMPTIVE REGISTER -  PL'!H21,\"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I18<>0, '5b. PRESUMPTIVE REGISTER -  PL'!H21<>0),'6b. LAB REGISTER - PL'!I18-'5b. PRESUMPTIVE REGISTER -  PL'!H21, \"NA\")","v":"NA"},{"$f":"IF(AND( '7b. TB TX REGISTER - PL'!Q16<>0,'7b. TB TX REGISTER - PL'!H16<>0), '7b. TB TX REGISTER - PL'!Q16-'7b. TB TX REGISTER - PL'!H16, \"NA\")","v":"NA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P9",{"$f":"IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!J22<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H22<>0), '5b. PRESUMPTIVE REGISTER -  PL'!J22-'5b. PRESUMPTIVE REGISTER -  PL'!H22, \"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I19<>0,'6b. LAB REGISTER - PL'!R19<>0),'6b. LAB REGISTER - PL'!R19-'6b. LAB REGISTER - PL'!I19,\"NA\")","v":"NA"},{"$f":"IF(AND('8b. TPT REGISTER - PL'!F16<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H22<>0),'8b. TPT REGISTER - PL'!F16-'5b. PRESUMPTIVE REGISTER -  PL'!H22,\"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I19<>0, '5b. PRESUMPTIVE REGISTER -  PL'!H22<>0),'6b. LAB REGISTER - PL'!I19-'5b. PRESUMPTIVE REGISTER -  PL'!H22, \"NA\")","v":"NA"},{"$f":"IF(AND( '7b. TB TX REGISTER - PL'!Q17<>0,'7b. TB TX REGISTER - PL'!H17<>0), '7b. TB TX REGISTER - PL'!Q17-'7b. TB TX REGISTER - PL'!H17, \"NA\")","v":"NA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P10",{"$f":"IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!J23<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H23<>0), '5b. PRESUMPTIVE REGISTER -  PL'!J23-'5b. PRESUMPTIVE REGISTER -  PL'!H23, \"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I20<>0,'6b. LAB REGISTER - PL'!R20<>0),'6b. LAB REGISTER - PL'!R20-'6b. LAB REGISTER - PL'!I20,\"NA\")","v":"NA"},{"$f":"IF(AND('8b. TPT REGISTER - PL'!F17<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H23<>0),'8b. TPT REGISTER - PL'!F17-'5b. PRESUMPTIVE REGISTER -  PL'!H23,\"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I20<>0, '5b. PRESUMPTIVE REGISTER -  PL'!H23<>0),'6b. LAB REGISTER - PL'!I20-'5b. PRESUMPTIVE REGISTER -  PL'!H23, \"NA\")","v":"NA"},{"$f":"IF(AND( '7b. TB TX REGISTER - PL'!Q18<>0,'7b. TB TX REGISTER - PL'!H18<>0), '7b. TB TX REGISTER - PL'!Q18-'7b. TB TX REGISTER - PL'!H18, \"NA\")","v":"NA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P11",{"$f":"IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!J24<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H24<>0), '5b. PRESUMPTIVE REGISTER -  PL'!J24-'5b. PRESUMPTIVE REGISTER -  PL'!H24, \"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I21<>0,'6b. LAB REGISTER - PL'!R21<>0),'6b. LAB REGISTER - PL'!R21-'6b. LAB REGISTER - PL'!I21,\"NA\")","v":"NA"},{"$f":"IF(AND('8b. TPT REGISTER - PL'!F18<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H24<>0),'8b. TPT REGISTER - PL'!F18-'5b. PRESUMPTIVE REGISTER -  PL'!H24,\"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I21<>0, '5b. PRESUMPTIVE REGISTER -  PL'!H24<>0),'6b. LAB REGISTER - PL'!I21-'5b. PRESUMPTIVE REGISTER -  PL'!H24, \"NA\")","v":"NA"},{"$f":"IF(AND( '7b. TB TX REGISTER - PL'!Q19<>0,'7b. TB TX REGISTER - PL'!H19<>0), '7b. TB TX REGISTER - PL'!Q19-'7b. TB TX REGISTER - PL'!H19, \"NA\")","v":"NA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P12",{"$f":"IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!J25<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H25<>0), '5b. PRESUMPTIVE REGISTER -  PL'!J25-'5b. PRESUMPTIVE REGISTER -  PL'!H25, \"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I22<>0,'6b. LAB REGISTER - PL'!R22<>0),'6b. LAB REGISTER - PL'!R22-'6b. LAB REGISTER - PL'!I22,\"NA\")","v":"NA"},{"$f":"IF(AND('8b. TPT REGISTER - PL'!F19<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H25<>0),'8b. TPT REGISTER - PL'!F19-'5b. PRESUMPTIVE REGISTER -  PL'!H25,\"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I22<>0, '5b. PRESUMPTIVE REGISTER -  PL'!H25<>0),'6b. LAB REGISTER - PL'!I22-'5b. PRESUMPTIVE REGISTER -  PL'!H25, \"NA\")","v":"NA"},{"$f":"IF(AND( '7b. TB TX REGISTER - PL'!Q20<>0,'7b. TB TX REGISTER - PL'!H20<>0), '7b. TB TX REGISTER - PL'!Q20-'7b. TB TX REGISTER - PL'!H20, \"NA\")","v":"NA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P13",{"$f":"IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!J26<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H26<>0), '5b. PRESUMPTIVE REGISTER -  PL'!J26-'5b. PRESUMPTIVE REGISTER -  PL'!H26, \"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I23<>0,'6b. LAB REGISTER - PL'!R23<>0),'6b. LAB REGISTER - PL'!R23-'6b. LAB REGISTER - PL'!I23,\"NA\")","v":"NA"},{"$f":"IF(AND('8b. TPT REGISTER - PL'!F20<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H26<>0),'8b. TPT REGISTER - PL'!F20-'5b. PRESUMPTIVE REGISTER -  PL'!H26,\"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I23<>0, '5b. PRESUMPTIVE REGISTER -  PL'!H26<>0),'6b. LAB REGISTER - PL'!I23-'5b. PRESUMPTIVE REGISTER -  PL'!H26, \"NA\")","v":"NA"},{"$f":"IF(AND( '7b. TB TX REGISTER - PL'!Q21<>0,'7b. TB TX REGISTER - PL'!H21<>0), '7b. TB TX REGISTER - PL'!Q21-'7b. TB TX REGISTER - PL'!H21, \"NA\")","v":"NA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P14",{"$f":"IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!J27<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H27<>0), '5b. PRESUMPTIVE REGISTER -  PL'!J27-'5b. PRESUMPTIVE REGISTER -  PL'!H27, \"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I24<>0,'6b. LAB REGISTER - PL'!R24<>0),'6b. LAB REGISTER - PL'!R24-'6b. LAB REGISTER - PL'!I24,\"NA\")","v":"NA"},{"$f":"IF(AND('8b. TPT REGISTER - PL'!F21<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H27<>0),'8b. TPT REGISTER - PL'!F21-'5b. PRESUMPTIVE REGISTER -  PL'!H27,\"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I24<>0, '5b. PRESUMPTIVE REGISTER -  PL'!H27<>0),'6b. LAB REGISTER - PL'!I24-'5b. PRESUMPTIVE REGISTER -  PL'!H27, \"NA\")","v":"NA"},{"$f":"IF(AND( '7b. TB TX REGISTER - PL'!Q22<>0,'7b. TB TX REGISTER - PL'!H22<>0), '7b. TB TX REGISTER - PL'!Q22-'7b. TB TX REGISTER - PL'!H22, \"NA\")","v":"NA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P15",{"$f":"IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!J28<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H28<>0), '5b. PRESUMPTIVE REGISTER -  PL'!J28-'5b. PRESUMPTIVE REGISTER -  PL'!H28, \"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I25<>0,'6b. LAB REGISTER - PL'!R25<>0),'6b. LAB REGISTER - PL'!R25-'6b. LAB REGISTER - PL'!I25,\"NA\")","v":"NA"},{"$f":"IF(AND('8b. TPT REGISTER - PL'!F22<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H28<>0),'8b. TPT REGISTER - PL'!F22-'5b. PRESUMPTIVE REGISTER -  PL'!H28,\"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I25<>0, '5b. PRESUMPTIVE REGISTER -  PL'!H28<>0),'6b. LAB REGISTER - PL'!I25-'5b. PRESUMPTIVE REGISTER -  PL'!H28, \"NA\")","v":"NA"},{"$f":"IF(AND( '7b. TB TX REGISTER - PL'!Q23<>0,'7b. TB TX REGISTER - PL'!H23<>0), '7b. TB TX REGISTER - PL'!Q23-'7b. TB TX REGISTER - PL'!H23, \"NA\")","v":"NA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P16",{"$f":"IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!J29<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H29<>0), '5b. PRESUMPTIVE REGISTER -  PL'!J29-'5b. PRESUMPTIVE REGISTER -  PL'!H29, \"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I26<>0,'6b. LAB REGISTER - PL'!R26<>0),'6b. LAB REGISTER - PL'!R26-'6b. LAB REGISTER - PL'!I26,\"NA\")","v":"NA"},{"$f":"IF(AND('8b. TPT REGISTER - PL'!F23<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H29<>0),'8b. TPT REGISTER - PL'!F23-'5b. PRESUMPTIVE REGISTER -  PL'!H29,\"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I26<>0, '5b. PRESUMPTIVE REGISTER -  PL'!H29<>0),'6b. LAB REGISTER - PL'!I26-'5b. PRESUMPTIVE REGISTER -  PL'!H29, \"NA\")","v":"NA"},{"$f":"IF(AND( '7b. TB TX REGISTER - PL'!Q24<>0,'7b. TB TX REGISTER - PL'!H24<>0), '7b. TB TX REGISTER - PL'!Q24-'7b. TB TX REGISTER - PL'!H24, \"NA\")","v":"NA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P17",{"$f":"IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!J30<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H30<>0), '5b. PRESUMPTIVE REGISTER -  PL'!J30-'5b. PRESUMPTIVE REGISTER -  PL'!H30, \"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I27<>0,'6b. LAB REGISTER - PL'!R27<>0),'6b. LAB REGISTER - PL'!R27-'6b. LAB REGISTER - PL'!I27,\"NA\")","v":"NA"},{"$f":"IF(AND('8b. TPT REGISTER - PL'!F24<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H30<>0),'8b. TPT REGISTER - PL'!F24-'5b. PRESUMPTIVE REGISTER -  PL'!H30,\"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I27<>0, '5b. PRESUMPTIVE REGISTER -  PL'!H30<>0),'6b. LAB REGISTER - PL'!I27-'5b. PRESUMPTIVE REGISTER -  PL'!H30, \"NA\")","v":"NA"},{"$f":"IF(AND( '7b. TB TX REGISTER - PL'!Q25<>0,'7b. TB TX REGISTER - PL'!H25<>0), '7b. TB TX REGISTER - PL'!Q25-'7b. TB TX REGISTER - PL'!H25, \"NA\")","v":"NA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P18",{"$f":"IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!J31<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H31<>0), '5b. PRESUMPTIVE REGISTER -  PL'!J31-'5b. PRESUMPTIVE REGISTER -  PL'!H31, \"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I28<>0,'6b. LAB REGISTER - PL'!R28<>0),'6b. LAB REGISTER - PL'!R28-'6b. LAB REGISTER - PL'!I28,\"NA\")","v":"NA"},{"$f":"IF(AND('8b. TPT REGISTER - PL'!F25<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H31<>0),'8b. TPT REGISTER - PL'!F25-'5b. PRESUMPTIVE REGISTER -  PL'!H31,\"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I28<>0, '5b. PRESUMPTIVE REGISTER -  PL'!H31<>0),'6b. LAB REGISTER - PL'!I28-'5b. PRESUMPTIVE REGISTER -  PL'!H31, \"NA\")","v":"NA"},{"$f":"IF(AND( '7b. TB TX REGISTER - PL'!Q26<>0,'7b. TB TX REGISTER - PL'!H26<>0), '7b. TB TX REGISTER - PL'!Q26-'7b. TB TX REGISTER - PL'!H26, \"NA\")","v":"NA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P19",{"$f":"IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!J32<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H32<>0), '5b. PRESUMPTIVE REGISTER -  PL'!J32-'5b. PRESUMPTIVE REGISTER -  PL'!H32, \"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I29<>0,'6b. LAB REGISTER - PL'!R29<>0),'6b. LAB REGISTER - PL'!R29-'6b. LAB REGISTER - PL'!I29,\"NA\")","v":"NA"},{"$f":"IF(AND('8b. TPT REGISTER - PL'!F26<>0,'5b. PRESUMPTIVE REGISTER -  PL'!H32<>0),'8b. TPT REGISTER - PL'!F26-'5b. PRESUMPTIVE REGISTER -  PL'!H32,\"NA\")","v":"NA"},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I29<>0, '5b. PRESUMPTIVE REGISTER -  PL'!H32<>0),'6b. LAB REGISTER - PL'!I29-'5b. PRESUMPTIVE REGISTER -  PL'!H32, \"NA\")","v":"NA"},{"$f":"IF(AND( '7b. TB TX REGISTER - PL'!Q27<>0,'7b. TB TX REGISTER - PL'!H27<>0), '7b. TB TX REGISTER - PL'!Q27-'7b. TB TX REGISTER - PL'!H27, \"NA\")","v":"NA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P20",{"$f":"IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!#REF!<>0,'5b. PRESUMPTIVE REGISTER -  PL'!#REF!<>0), '5b. PRESUMPTIVE REGISTER -  PL'!#REF!-'5b. PRESUMPTIVE REGISTER -  PL'!#REF!, \"NA\")","v":{"$error":"#REF!"}},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I30<>0,'6b. LAB REGISTER - PL'!R30<>0),'6b. LAB REGISTER - PL'!R30-'6b. LAB REGISTER - PL'!I30,\"NA\")","v":"NA"},{"$f":"IF(AND('8b. TPT REGISTER - PL'!F27<>0,'5b. PRESUMPTIVE REGISTER -  PL'!#REF!<>0),'8b. TPT REGISTER - PL'!F27-'5b. PRESUMPTIVE REGISTER -  PL'!#REF!,\"NA\")","v":{"$error":"#REF!"}},{"$f":"IF(AND('6b. LAB REGISTER - PL'!I30<>0, '5b. PRESUMPTIVE REGISTER -  PL'!#REF!<>0),'6b. LAB REGISTER - PL'!I30-'5b. PRESUMPTIVE REGISTER -  PL'!#REF!, \"NA\")","v":{"$error":"#REF!"}},{"$f":"IF(AND( '7b. TB TX REGISTER - PL'!Q28<>0,'7b. TB TX REGISTER - PL'!H28<>0), '7b. TB TX REGISTER - PL'!Q28-'7b. TB TX REGISTER - PL'!H28, \"NA\")","v":"NA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Average",{"$f":"IF(ISNUMBER(AVERAGE(TAT[DIAGNOSIS\n(From date of specimen collection to date of NAAT result received by clinic)])), SUMIF(O37:O56,\">-1\")/$C$36, \"NA\")","v":"NA"},{"$f":"IF(ISNUMBER(AVERAGE(TAT[LAB TURNAROUND\n(From date specimens received by lab to date of NAAT result released)])), SUMIF(P37:P56,\">-1\")/$C$36, \"NA\")","v":"NA"},{"$f":"IF(ISNUMBER(AVERAGE(TAT[TREATMENT INITIATION\n(From date of specimen collection to date patients begin treatment)])), SUMIF(Q37:Q56,\">-1\")/$C$36, \"NA\")","v":"NA"},{"$f":"IF(ISNUMBER(AVERAGE(TAT[SPECIMEN TRANSFER \n(From date of specimen collection to date specimen received by lab) ])), SUMIF(R37:R56,\">-10\")/COUNTIFS(PLLab[Available in Lab Register?],\"Yes\"), \"NA\")","v":"NA"},{"$f":"IF(ISNUMBER(AVERAGE(TAT[TB TREATMENT \n(From date of treatment initiation to date of treatment outcome)])), AVERAGE(IF(ISNUMBER(TAT[TB TREATMENT \n(From date of treatment initiation to date of treatment outcome)]),TAT[TB TREATMENT \n(From date of treatment initiation to date of treatment outcome)])), \"NA\")","v":"NA"}]
[]
["top"]
[null,"ADDITIONAL FIGURES"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Aggregate Presumptive TB Profile ","Per1","Per2","Per3","Total",null,"Aggregate Treatment Outcomes",null,null,"Per1","Per2","Per3","Total"]
[null,"Total Patients",{"$f":"AggPresumptiveP1[[#Totals],[Total Presumptive TB]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[Total Presumptive TB]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[Total Presumptive TB]]","v":0},{"$f":"SUM(C78:E78)","v":0},null,"Registered",null,null,{"$f":"AggTreatmentP1[[#Totals],[Total Patients ]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Total Patients ]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Total Patients ]]","v":0},{"$f":"SUM(K78:M78)","v":0}]
[null,"Female",{"$f":"AggPresumptiveP1[[#Totals],[Females]]/C78","v":{"$error":"#DIV/0!"}},{"$f":"AggPresumptiveP2[[#Totals],[Females]]/D78","v":{"$error":"#DIV/0!"}},{"$f":"AggPresumptiveP3[[#Totals],[Females]]/E78","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C79:E79)","v":{"$error":"#DIV/0!"}},null,"Completed",null,null,{"$f":"AggTreatmentP1[[#Totals],[ Completed\nTreatment\n(CTD)]]/K78","v":{"$error":"#DIV/0!"}},{"$f":"AggTreatmentP2[[#Totals],[ Completed\nTreatment\n(CTD)]]/L78","v":{"$error":"#DIV/0!"}},{"$f":"AggTreatmentP3[[#Totals],[ Completed\nTreatment\n(CTD)]]/M78","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K79:M79)","v":{"$error":"#DIV/0!"}}]
[null,"Male",{"$f":"AggPresumptiveP1[[#Totals],[Males]]/C78","v":{"$error":"#DIV/0!"}},{"$f":"AggPresumptiveP2[[#Totals],[Males]]/D78","v":{"$error":"#DIV/0!"}},{"$f":"AggPresumptiveP3[[#Totals],[Males]]/E78","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C80:E80)","v":{"$error":"#DIV/0!"}},null,"Cured",null,null,{"$f":"AggTreatmentP1[[#Totals],[Cured\n(C)]]/K78","v":{"$error":"#DIV/0!"}},{"$f":"AggTreatmentP2[[#Totals],[Cured\n(C)]]/L78","v":{"$error":"#DIV/0!"}},{"$f":"AggTreatmentP3[[#Totals],[Cured\n(C)]]/M78","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K80:M80)","v":{"$error":"#DIV/0!"}}]
[null,"0 - 14 Years",{"$f":"AggPresumptiveP1[[#Totals],[Age 0-14]]/C78","v":{"$error":"#DIV/0!"}},{"$f":"AggPresumptiveP2[[#Totals],[Age 0-14]]/D78","v":{"$error":"#DIV/0!"}},{"$f":"AggPresumptiveP3[[#Totals],[Age 0-14]]/E78","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,"Failed",null,null,{"$f":"AggTreatmentP1[[#Totals],[Treatment Failed\n(F)]]/K78","v":{"$error":"#DIV/0!"}},{"$f":"AggTreatmentP2[[#Totals],[Treatment Failed\n(F)]]/L78","v":{"$error":"#DIV/0!"}},{"$f":"AggTreatmentP3[[#Totals],[Treatment Failed\n(F)]]/M78","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"15+ Years",{"$f":"AggPresumptiveP1[[#Totals],[Age 15+ ]]/C78","v":{"$error":"#DIV/0!"}},{"$f":"AggPresumptiveP2[[#Totals],[Age 15+ ]]/D78","v":{"$error":"#DIV/0!"}},{"$f":"AggPresumptiveP3[[#Totals],[Age 15+ ]]/E78","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C82:E82)","v":{"$error":"#DIV/0!"}},null,"Died",null,null,{"$f":"AggTreatmentP1[[#Totals],[Died\n(D)]]/K78","v":{"$error":"#DIV/0!"}},{"$f":"AggTreatmentP2[[#Totals],[Died\n(D)]]/L78","v":{"$error":"#DIV/0!"}},{"$f":"AggTreatmentP3[[#Totals],[Died\n(D)]]/M78","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"HIV-Negative",{"$f":"AggPresumptiveP1[[#Totals],[HIV Negative]]/C78","v":{"$error":"#DIV/0!"}},{"$f":"AggPresumptiveP2[[#Totals],[HIV Negative]]/D78","v":{"$error":"#DIV/0!"}},{"$f":"AggPresumptiveP3[[#Totals],[HIV Negative]]/E78","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,"LTFU",null,null,{"$f":"AggTreatmentP1[[#Totals],[Lost to Follow-up\n(L)]]/K78","v":{"$error":"#DIV/0!"}},{"$f":"AggTreatmentP2[[#Totals],[Lost to Follow-up\n(L)]]/L78","v":{"$error":"#DIV/0!"}},{"$f":"AggTreatmentP3[[#Totals],[Lost to Follow-up\n(L)]]/M78","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"HIV-Positive",{"$f":"AggPresumptiveP1[[#Totals],[HIV Positive]]/C78","v":{"$error":"#DIV/0!"}},{"$f":"AggPresumptiveP2[[#Totals],[HIV Positive]]/D78","v":{"$error":"#DIV/0!"}},{"$f":"AggPresumptiveP3[[#Totals],[HIV Positive]]/E78","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,"Transferred",null,null,{"$f":"AggTreatmentP1[[#Totals],[Transferred Out]]/K78","v":{"$error":"#DIV/0!"}},{"$f":"AggTreatmentP2[[#Totals],[Transferred Out]]/L78","v":{"$error":"#DIV/0!"}},{"$f":"AggTreatmentP3[[#Totals],[Transferred Out]]/M78","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Patient-Level Presumptive TB Profile ","Total",null,null,null,null,"Patient-Level Treatment Outcomes",null,null,null,"Total"]
[null,"Individuals with Presumptive TB",{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!D9","v":0},null,null,null,null,"Registered",null,null,null,{"$f":"COUNTIFS(PLTreatment[Available in Register?],\"Yes\")","v":0}]
[null,"Female",{"$f":"(COUNTIFS(PLPresumptive[Sex],\"Female\"))/C103","v":{"$error":"#DIV/0!"}},null,null,null,null,"Completed",null,null,null,{"$f":"(COUNTIFS(PLTreatment[Treatment Outcome],\"Treatment Completed\"))/L103","v":{"$error":"#DIV/0!"}}]
[null,"Male",{"$f":"(COUNTIFS(PLPresumptive[Sex],\"Male\"))/C103","v":{"$error":"#DIV/0!"}},null,null,null,null,"Cured",null,null,null,{"$f":"(COUNTIFS(PLTreatment[Treatment Outcome],\"Cured\"))/L103","v":{"$error":"#DIV/0!"}}]
[null,"0 - 14 Years",{"$f":"(COUNTIFS(PLPresumptive[Age \n(<15, 15+)],\"0-14\"))/C103","v":{"$error":"#DIV/0!"}},null,null,null,null,"Failed",null,null,null,{"$f":"(COUNTIFS(PLTreatment[Treatment Outcome],\"Treatment Failed\"))/L103","v":{"$error":"#DIV/0!"}}]
[null,"15+ Years",{"$f":"(COUNTIFS(PLPresumptive[Age \n(<15, 15+)],\"15+\"))/C103","v":{"$error":"#DIV/0!"}},null,null,null,null,"Died",null,null,null,{"$f":"(COUNTIFS(PLTreatment[Treatment Outcome],\"Died\"))/L103","v":{"$error":"#DIV/0!"}}]
[null,"HIV-Negative",{"$f":"(COUNTIFS(PLPresumptive[Known HIV Status], \"Positive\")+COUNTIFS(PLPresumptive[Unknown HIV Status],\"Positive\"))/C103","v":{"$error":"#DIV/0!"}},null,null,null,null,"LTFU",null,null,null,{"$f":"(COUNTIFS(PLTreatment[Treatment Outcome], \"Lost to Follow-up\"))/L103","v":{"$error":"#DIV/0!"}}]
[null,"HIV-Positive",{"$f":"(COUNTIFS(PLPresumptive[Known HIV Status], \"Negative\")+COUNTIFS(PLPresumptive[Unknown HIV Status],\"Negative\"))/C103","v":{"$error":"#DIV/0!"}},null,null,null,null,"Transferred",null,null,null,{"$f":"(COUNTIFS(PLTreatment[Treatment Outcome],\"Transferred\"))/L103","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Removed from Register",null,null,null,{"$f":"(COUNTIFS(PLTreatment[Treatment Outcome],\"Removed from Register\"))/L103","v":{"$error":"#DIV/0!"}}]
["top"]
[" ","TPT"]
[]
[null,"TPT Descriptive Details","Per1","Per2","Per3","Total"]
[null,"TPT Started",{"$f":"AggTPTP1[[#Totals],[Total Patients ]]","v":0},{"$f":"AggTPTP2[[#Totals],[Total Patients ]]","v":0},{"$f":"AggTPTP3[[#Totals],[Total Patients ]]","v":0},{"$f":"SUM(C115:E115)","v":0}]
[null,"   Females",{"$f":"AggTPTP1[[#Totals],[Female]]","v":0},{"$f":"AggTPTP2[[#Totals],[Female]]","v":0},{"$f":"AggTPTP3[[#Totals],[Female]]","v":0},{"$f":"SUM(C116:E116)","v":0}]
[null,"   Males",{"$f":"AggTPTP1[[#Totals],[Male]]","v":0},{"$f":"AggTPTP2[[#Totals],[Male]]","v":0},{"$f":"AggTPTP3[[#Totals],[Male]]","v":0},{"$f":"SUM(C117:E117)","v":0}]
[null,"   0-14",{"$f":"AggTPTP1[[#Totals],[Age 0-14]]","v":0},{"$f":"AggTPTP2[[#Totals],[Age 0-14]]","v":0},{"$f":"AggTPTP3[[#Totals],[Age 0-14]]","v":0},{"$f":"SUM(C118:E118)","v":0}]
[null,"   15+",{"$f":"AggTPTP1[[#Totals],[Age 15+]]","v":0},{"$f":"AggTPTP2[[#Totals],[Age 15+]]","v":0},{"$f":"AggTPTP3[[#Totals],[Age 15+]]","v":0},{"$f":"SUM(C119:E119)","v":0}]
[null,"   New on ART",{"$f":"AggTPTP1[[#Totals],[PLHIV newly enrolled on into HIV care and treatment]]","v":0},{"$f":"AggTPTP2[[#Totals],[PLHIV newly enrolled on into HIV care and treatment]]","v":0},{"$f":"AggTPTP3[[#Totals],[PLHIV newly enrolled on into HIV care and treatment]]","v":0},0]
[null,"   Existing on ART",{"$f":"AggTPTP1[[#Totals],[PLHIV on follow-up visit for HIV care and treatment ]]","v":0},{"$f":"AggTPTP2[[#Totals],[PLHIV on follow-up visit for HIV care and treatment ]]","v":0},{"$f":"AggTPTP3[[#Totals],[PLHIV on follow-up visit for HIV care and treatment ]]","v":0},0]
[null,"Outcome"]
[null,"   Completed TPT",{"$f":"AggTPTP1[[#Totals],[IPT Completed]]","v":0},{"$f":"AggTPTP2[[#Totals],[IPT Completed]]","v":0},{"$f":"AggTPTP3[[#Totals],[IPT Completed]]","v":0},{"$f":"SUM(C123:E123)","v":0}]
[null,"   Developed Active TB",{"$f":"AggTPTP1[[#Totals],[Developed active TB]]","v":0},{"$f":"AggTPTP2[[#Totals],[Developed active TB]]","v":0},{"$f":"AggTPTP3[[#Totals],[Developed active TB]]","v":0},{"$f":"SUM(C124:E124)","v":0}]
[null,"   Died",{"$f":"AggTPTP1[[#Totals],[Died]]","v":0},{"$f":"AggTPTP2[[#Totals],[Died]]","v":0},{"$f":"AggTPTP3[[#Totals],[Died]]","v":0},{"$f":"SUM(C125:E125)","v":0}]
[null,"   Transferred Out",{"$f":"AggTPTP1[[#Totals],[Transferred out]]","v":0},{"$f":"AggTPTP2[[#Totals],[Transferred out]]","v":0},{"$f":"AggTPTP3[[#Totals],[Transferred out]]","v":0},{"$f":"SUM(C126:E126)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"TPT Cascade",null,"Per1","Per2","Per3","Total"]
[null,null,null,null,null,null,null,null,"TPT Started",null,{"$f":"AggTPTP1[[#Totals],[Total Patients ]]","v":0},{"$f":"AggTPTP2[[#Totals],[Total Patients ]]","v":0},{"$f":"AggTPTP3[[#Totals],[Total Patients ]]","v":0},{"$f":"SUM(K147:M147)","v":0}]
[null,null,null,null,null,null,null,null,"Outcome",null,{"$f":"SUM(AggTPTP1[[#Totals],[IPT Completed]:[Transferred out]])","v":0},{"$f":"SUM(AggTPTP2[[#Totals],[IPT Completed]:[Transferred out]])","v":0},{"$f":"SUM(AggTPTP3[[#Totals],[IPT Completed]:[Transferred out]])","v":0},{"$f":"SUM(K148:M148)","v":0}]
[null,null,null,null,null,null,null,null,"   Completed TPT",null,{"$f":"AggTPTP1[[#Totals],[IPT Completed]]","v":0},{"$f":"AggTPTP2[[#Totals],[IPT Completed]]","v":0},{"$f":"AggTPTP3[[#Totals],[IPT Completed]]","v":0},0]
[null,null,null,null,null,null,null,null,"   Developed Active TB",null,{"$f":"AggTPTP1[[#Totals],[Developed active TB]]","v":0},{"$f":"AggTPTP2[[#Totals],[Developed active TB]]","v":0},{"$f":"AggTPTP3[[#Totals],[Developed active TB]]","v":0},0]
[null,null,null,null,null,null,null,null,"   Died",null,{"$f":"AggTPTP1[[#Totals],[Died]]","v":0},{"$f":"AggTPTP2[[#Totals],[Died]]","v":0},{"$f":"AggTPTP3[[#Totals],[Died]]","v":0},0]
[null,null,null,null,null,null,null,null,"   Transferred Out",null,{"$f":"AggTPTP1[[#Totals],[Transferred out]]","v":0},{"$f":"AggTPTP2[[#Totals],[Transferred out]]","v":0},{"$f":"AggTPTP3[[#Totals],[Transferred out]]","v":0},0]
[]
[]
[]
[]
[]
[]
[]
["top"]

{"sheet":"3. TABLE SUMMARIES","index":3,"n_rows":42,"n_cols":27,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,15,3,16],[3,1,3,2],[30,1,30,6],[2,8,2,13],[3,8,3,9],[29,8,29,13],[0,15,0,20],[0,8,0,13],[0,22,0,27],[2,22,2,26],[0,1,0,6],[2,1,2,6],[2,15,2,20]]}
[null,"PRESUMPTIVE TB REGISTER: AGGREGATE-LEVEL DATA",null,null,null,null,null,null,"LAB REGISTER: AGGREGATE-LEVEL DATA",null,null,null,null,null,null,"TB TREATMENT REGISTER: AGGREGATE-LEVEL DATA",null,null,null,null,null,null,"TPT REGISTER: AGGREGATE-LEVEL DATA"]
[]
[null,"TB CLINIC PRESUMPTIVE TB REGISTER: AGGREGATE-LEVEL",null,null,null,null,null,null,"LAB REGISTER: AGGREGATE-LEVEL\n-Diagnosis testing only, excluding referral site samples-",null,null,null,null,null,null,"TB TREATMENT REGISTER: AGGREGATE-LEVEL",null,null,null,null,null,null,"TB TREATMENT REGISTER: AGGREGATE-LEVEL"]
[null,"CATEGORY",null,"Period 1","Period 2","Period 3","TOTAL",null,"CATEGORY",null,"Period 1","Period 2","Period 3","TOTAL",null,"CATEGORY",null,"Period 1","Period 2","Period 3","TOTAL",null,"TPT Descriptive Details","Period 1","Period 2","Period 3","Total"]
[null,"Total Presumptive TB",null,{"$f":"AggPresumptiveP1[[#Totals],[Total Presumptive TB]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[Total Presumptive TB]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[Total Presumptive TB]]","v":0},{"$f":"SUM(D5:F5)","v":0},null,"Total Specimens",null,{"$f":"AggLabP1[[#Totals],[Total Specimens]]","v":0},{"$f":"AggLabP2[[#Totals],[Total Specimens]]","v":0},{"$f":"AggLabP3[[#Totals],[Total Specimens]]","v":0},{"$f":"SUM(K5:M5)","v":0},null,"Total Patients",null,{"$f":"AggTreatmentP1[[#Totals],[Total Patients ]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Total Patients ]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Total Patients ]]","v":0},{"$f":"SUM(R5:T5)","v":0},null,"TPT Started",{"$f":"AggTPTP1[[#Totals],[Total Patients ]]","v":0},{"$f":"AggTPTP2[[#Totals],[Total Patients ]]","v":0},{"$f":"AggTPTP3[[#Totals],[Total Patients ]]","v":0},{"$f":"SUM(X5:Z5)","v":0}]
[null,"Age",null,null,null,null,null,null,"Sex",null,null,null,null,null,null,"Sex",null,null,null,null,null,null,"   Females",{"$f":"AggTPTP1[[#Totals],[Female]]","v":0},0,0,{"$f":"SUM(X6:Z6)","v":0}]
[null,null,"Age (0 - 14)",{"$f":"AggPresumptiveP1[[#Totals],[Age 0-14]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[Age 0-14]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[Age 0-14]]","v":0},{"$f":"SUM(D7:F7)","v":0},null,null,"Female",{"$f":"AggLabP1[[#Totals],[Female]]","v":0},{"$f":"AggLabP2[[#Totals],[Female]]","v":0},{"$f":"AggLabP3[[#Totals],[Female]]","v":0},{"$f":"SUM(K7:M7)","v":0},null,null,"Female",{"$f":"AggTreatmentP1[[#Totals],[Female]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Female]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Female]]","v":0},{"$f":"SUM(R7:T7)","v":0},null,"   Males",{"$f":"AggTPTP1[[#Totals],[Male]]","v":0},0,0,{"$f":"SUM(X7:Z7)","v":0}]
[null,null,"Age (15+)",{"$f":"AggPresumptiveP1[[#Totals],[Age 15+ ]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[Age 15+ ]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[Age 15+ ]]","v":0},{"$f":"SUM(D8:F8)","v":0},null,null,"Male",{"$f":"AggLabP1[[#Totals],[Male]]","v":0},{"$f":"AggLabP2[[#Totals],[Male]]","v":0},{"$f":"AggLabP3[[#Totals],[Male]]","v":0},{"$f":"SUM(K8:M8)","v":0},null,null,"Male",{"$f":"AggTreatmentP1[[#Totals],[Male]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Male]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Male]]","v":0},{"$f":"SUM(R8:T8)","v":0},null,"   0-14",{"$f":"AggTPTP1[[#Totals],[Age 0-14]]","v":0},0,0,{"$f":"SUM(X8:Z8)","v":0}]
[null,"Sex",null,null,null,null,null,null,"Age",null,null,null,null,null,null,"Age",null,null,null,null,null,null,"   15+",{"$f":"AggTPTP1[[#Totals],[Age 15+]]","v":0},0,0,{"$f":"SUM(X9:Z9)","v":0}]
[null,null,"Males",{"$f":"AggPresumptiveP1[[#Totals],[Males]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[Males]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[Males]]","v":0},{"$f":"SUM(D10:F10)","v":0},null,null,"Age (0 - 14)",{"$f":"AggLabP1[[#Totals],[Age 0-14]]","v":0},{"$f":"AggLabP2[[#Totals],[Age 0-14]]","v":0},{"$f":"AggLabP3[[#Totals],[Age 0-14]]","v":0},{"$f":"SUM(K10:M10)","v":0},null,null,"Age (0 - 14)",{"$f":"AggTreatmentP1[[#Totals],[Age 0-14]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Age 0-14]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Age 0-14]]","v":0},{"$f":"SUM(R10:T10)","v":0},null,"   New on ART",{"$f":"AggTPTP1[[#Totals],[PLHIV newly enrolled on into HIV care and treatment]]","v":0},0,0,0]
[null,null,"Females",{"$f":"AggPresumptiveP1[[#Totals],[Females]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[Females]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[Females]]","v":0},{"$f":"SUM(D11:F11)","v":0},null,null,"Age (15+)",{"$f":"AggLabP1[[#Totals],[Age 15+]]","v":0},{"$f":"AggLabP2[[#Totals],[Age 15+]]","v":0},{"$f":"AggLabP3[[#Totals],[Age 15+]]","v":0},{"$f":"SUM(K11:M11)","v":0},null,null,"Age (15+)",{"$f":"AggTreatmentP1[[#Totals],[Age 15+]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Age 15+]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Age 15+]]","v":0},0,null,"   Existing on ART",{"$f":"AggTPTP1[[#Totals],[PLHIV on follow-up visit for HIV care and treatment ]]","v":0},0,0,0]
[null,"Documented Specimens Collected",null,{"$f":"AggPresumptiveP1[[#Totals],[Number Specimens Collected]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[Number Specimens Collected]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[Number Specimens Collected]]","v":0},{"$f":"SUM(D12:F12)","v":0},null,"Known HIV Status",null,null,null,null,{"$f":"SUM(N13:N14)","v":0},null,"Type of Patient",null,null,null,null,null,null,"Outcome"]
[null,"Smear Activities",null,null,null,null,null,null,null,"Positive",{"$f":"AggLabP1[[#Totals],[Positive]]","v":0},{"$f":"AggLabP2[[#Totals],[Positive]]","v":0},{"$f":"AggLabP3[[#Totals],[Positive]]","v":0},{"$f":"SUM(K13:M13)","v":0},null,null,"New (N)",{"$f":"AggTreatmentP1[[#Totals],[New \n(N)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[New \n(N)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[New \n(N)]]","v":0},{"$f":"SUM(R13:T13)","v":0},null,"   Completed TPT",{"$f":"AggTPTP1[[#Totals],[IPT Completed]]","v":0},{"$f":"AggTPTP2[[#Totals],[IPT Completed]]","v":0},{"$f":"AggTPTP3[[#Totals],[IPT Completed]]","v":0},{"$f":"SUM(X13:Z13)","v":0}]
[null,null,"AFB (-)",{"$f":"AggPresumptiveP1[[#Totals],[AFB (-)]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[AFB (-)]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[AFB (-)]]","v":0},{"$f":"SUM(D14:F14)","v":0},null,null,"Negative",{"$f":"AggLabP1[[#Totals],[Negative]]","v":0},{"$f":"AggLabP2[[#Totals],[Negative]]","v":0},{"$f":"AggLabP3[[#Totals],[Negative]]","v":0},{"$f":"SUM(K14:M14)","v":0},null,null,"Relapse (R)",{"$f":"AggTreatmentP1[[#Totals],[Relapse (R)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Relapse (R)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Relapse (R)]]","v":0},0,null,"   Developed Active TB",{"$f":"AggTPTP1[[#Totals],[Developed active TB]]","v":0},{"$f":"AggTPTP2[[#Totals],[Developed active TB]]","v":0},{"$f":"AggTPTP3[[#Totals],[Developed active TB]]","v":0},{"$f":"SUM(X14:Z14)","v":0}]
[null,null,"AFB (+)",{"$f":"AggPresumptiveP1[[#Totals],[AFB (+)]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[AFB (+)]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[AFB (+)]]","v":0},0,null,"Unknown HIV Status",null,null,null,null,{"$f":"SUM(N16:N16)","v":0},null,null,"Treatment After Failure (TF)",{"$f":"AggTreatmentP1[[#Totals],[Treatment After Failure (TF)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Treatment After Failure (TF)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Treatment After Failure (TF)]]","v":0},0,null,"   Died",{"$f":"AggTPTP1[[#Totals],[Died]]","v":0},{"$f":"AggTPTP2[[#Totals],[Died]]","v":0},{"$f":"AggTPTP3[[#Totals],[Died]]","v":0},{"$f":"SUM(X15:Z15)","v":0}]
[null,"NAAT Activities",null,null,null,null,null,null,null,"Not Tested",{"$f":"AggLabP1[[#Totals],[Not Tested]]","v":0},{"$f":"AggLabP2[[#Totals],[Not Tested]]","v":0},{"$f":"AggLabP3[[#Totals],[Not Tested]]","v":0},{"$f":"SUM(K16:M16)","v":0},null,null,"Treatment After Loss to Follow-up (TL)",{"$f":"AggTreatmentP1[[#Totals],[Treatment After Loss to Follow-up (TL)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Treatment After Loss to Follow-up (TL)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Treatment After Loss to Follow-up (TL)]]","v":0},0,null,"   Transferred Out",{"$f":"AggTPTP1[[#Totals],[Transferred out]]","v":0},{"$f":"AggTPTP2[[#Totals],[Transferred out]]","v":0},{"$f":"AggTPTP3[[#Totals],[Transferred out]]","v":0},{"$f":"SUM(X16:Z16)","v":0}]
[null,null,"MTB Not Detected",{"$f":"AggPresumptiveP1[[#Totals],[MTB Not Detected\n(N)]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[MTB Not Detected\n(N)]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[MTB Not Detected\n(N)]]","v":0},0,null,"Smear Activities",null,null,null,null,null,null,null,"Unknown Previous TB Treatment History (THU)",{"$f":"AggTreatmentP1[[#Totals],[Treatment History Unknown\n (THU)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Treatment History Unknown\n (THU)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Treatment History Unknown\n (THU)]]","v":0},0]
[null,null,"MTB Detected, RIF Resistance Not Detected",{"$f":"AggPresumptiveP1[[#Totals],[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)]]","v":0},0,null,null,"AFB (-)",{"$f":"AggLabP1[[#Totals],[AFB (-)]]","v":0},{"$f":"AggLabP2[[#Totals],[AFB (-)]]","v":0},{"$f":"AggLabP3[[#Totals],[AFB (-)]]","v":0},{"$f":"SUM(K18:M18)","v":0},null,null,"Transfer In (TI)",{"$f":"AggTreatmentP1[[#Totals],[Transfer In]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Transfer In]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Transfer In]]","v":0},0]
[null,null,"MTB Detected, RIF Resistance Detected",{"$f":"AggPresumptiveP1[[#Totals],[MTB Detected (including trace), \nRIF Resistance Detected\n(RR)]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[MTB Detected (including trace), \nRIF Resistance Detected\n(RR)]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[MTB Detected (including trace), \nRIF Resistance Detected\n(RR)]]","v":0},0,null,null,"AFB (+)",{"$f":"AggLabP1[[#Totals],[AFB (+)]]","v":0},{"$f":"AggLabP2[[#Totals],[AFB (+)]]","v":0},{"$f":"AggLabP3[[#Totals],[AFB (+)]]","v":0},{"$f":"SUM(K19:M19)","v":0},null,"AFB"]
[null,null,"MTB Detected, RIF Resistance Indeterminate",{"$f":"AggPresumptiveP1[[#Totals],[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)]]","v":0},0,null,"NAAT Activities",null,null,null,null,null,null,null,"Not Done (ND)",{"$f":"AggTreatmentP1[[#Totals],[Not Done (ND)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Not Done (ND)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Not Done (ND)]]","v":0}]
[null,null,"Error/Incomplete/Invalid",{"$f":"AggPresumptiveP1[[#Totals],[Inavlid\nNo Result Error\n(I)]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[Inavlid\nNo Result Error\n(I)]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[Inavlid\nNo Result Error\n(I)]]","v":0},0,null,null,"MTB Not Detected",{"$f":"AggLabP1[[#Totals],[MTB Not Detected\n(N)]]","v":0},{"$f":"AggLabP2[[#Totals],[MTB Not Detected\n(N)]]","v":0},{"$f":"AggLabP3[[#Totals],[MTB Not Detected\n(N)]]","v":0},{"$f":"SUM(K21:M21)","v":0},null,null,"AFB (+)",{"$f":"AggTreatmentP1[[#Totals],[Smear Postive (+/ ++/ +++)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Smear Postive (+/ ++/ +++)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Smear Postive (+/ ++/ +++)]]","v":0},{"$f":"SUM(R21:T21)","v":0}]
[null,"TB Lam Activities",null,null,null,null,null,null,null,"MTB Detected, RIF Resistance Not Detected",{"$f":"AggLabP1[[#Totals],[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)]]","v":0},{"$f":"AggLabP2[[#Totals],[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)]]","v":0},{"$f":"AggLabP3[[#Totals],[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)]]","v":0},{"$f":"SUM(K22:M22)","v":0},null,null,"AFB (-)",{"$f":"AggTreatmentP1[[#Totals],[Smear Negative (-)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Smear Negative (-)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Smear Negative (-)]]","v":0},{"$f":"SUM(R22:T22)","v":0}]
[null,null,"LAM Positive",{"$f":"AggPresumptiveP1[[#Totals],[LAM Positive]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[LAM Positive]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[LAM Positive]]","v":0},{"$f":"SUM(D23:F23)","v":0},null,null,"MTB Detected, RIF Resistance Detected",{"$f":"AggLabP1[[#Totals],[MTB Detected (including trace), \nRIF Resistance Detected\n(RR)]]","v":0},{"$f":"AggLabP2[[#Totals],[MTB Detected (including trace), \nRIF Resistance Detected\n(RR)]]","v":0},{"$f":"AggLabP3[[#Totals],[MTB Detected (including trace), \nRIF Resistance Detected\n(RR)]]","v":0},{"$f":"SUM(K23:M23)","v":0},null,"NAAT Activities"]
[null,null,"LAM Negative",{"$f":"AggPresumptiveP1[[#Totals],[LAM Negative]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[LAM Negative]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[LAM Negative]]","v":0},{"$f":"SUM(D24:F24)","v":0},null,null,"MTB Detected, RIF Resistance Indeterminate",{"$f":"AggLabP1[[#Totals],[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)]]","v":0},{"$f":"AggLabP2[[#Totals],[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)]]","v":0},{"$f":"AggLabP3[[#Totals],[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)]]","v":0},{"$f":"SUM(K24:M24)","v":0},null,null,"MTB Not Detected",{"$f":"AggTreatmentP1[[#Totals],[MTB Not Detected\n(N)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[MTB Not Detected\n(N)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[MTB Not Detected\n(N)]]","v":0},{"$f":"SUM(R24:T24)","v":0}]
[null,null,"Invalid",{"$f":"AggPresumptiveP1[[#Totals],[Invalid]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[Invalid]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[Invalid]]","v":0},0,null,null,"Error/Incomplete/Invalid",{"$f":"AggLabP1[[#Totals],[Inavlid\nNo Result Error\n(I)]]","v":0},{"$f":"AggLabP2[[#Totals],[Inavlid\nNo Result Error\n(I)]]","v":0},{"$f":"AggLabP3[[#Totals],[Inavlid\nNo Result Error\n(I)]]","v":0},{"$f":"SUM(K25:M25)","v":0},null,null,"MTB Detected, RIF Resistance Not Detected",{"$f":"AggTreatmentP1[[#Totals],[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)]]","v":0},{"$f":"SUM(R25:T25)","v":0}]
[null,"Known HIV Status",null,null,null,null,null,null,"TB LAM Activities",null,null,null,null,null,null,null,"MTB Detected, RIF Resistance Detected",{"$f":"AggTreatmentP1[[#Totals],[MTB Detected (including trace), \nRIF Resistance Detected\n(RR)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[MTB Detected (including trace), \nRIF Resistance Detected\n(RR)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[MTB Detected (including trace), \nRIF Resistance Detected\n(RR)]]","v":0},{"$f":"SUM(R26:T26)","v":0}]
[null,null,"Positive",{"$f":"AggPresumptiveP1[[#Totals],[HIV Positive]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[HIV Positive]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[HIV Positive]]","v":0},{"$f":"SUM(D27:F27)","v":0},null,null,"LAM Positive",{"$f":"AggLabP1[[#Totals],[LAM Positive]]","v":0},{"$f":"AggLabP2[[#Totals],[LAM Positive]]","v":0},{"$f":"AggLabP2[[#Totals],[LAM Positive]]","v":0},{"$f":"SUM(K27:M27)","v":0},null,null,"MTB Detected, RIF Resistance Indeterminate",{"$f":"AggTreatmentP1[[#Totals],[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)]]","v":0}]
[null,null,"Negative",{"$f":"AggPresumptiveP1[[#Totals],[HIV Negative]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[HIV Negative]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[HIV Negative]]","v":0},{"$f":"SUM(D28:F28)","v":0},null,null,"LAM Negative",null,null,null,{"$f":"SUM(K28:M28)","v":0},null,null,"Error/Incomplete/Invalid",{"$f":"AggTreatmentP1[[#Totals],[Inavlid\nNo Result Error\n(I)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Inavlid\nNo Result Error\n(I)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Inavlid\nNo Result Error\n(I)]]","v":0},{"$f":"SUM(R28:T28)","v":0}]
[null,"Unknown HIV Status",null,null,null,null,null,null,null,"LAM Invalid",null,null,null,0,null,"Treatment Outcome"]
[null,null,"Not Tested",{"$f":"AggPresumptiveP1[[#Totals],[Not Tested]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[Not Tested]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[Not Tested]]","v":0},{"$f":"SUM(D30:F30)","v":0},null,"Notes: *unable to disaggregate results for \"MTB Detected\" ",null,null,null,null,null,null,null,"Cured",{"$f":"AggTreatmentP1[[#Totals],[Cured\n(C)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Cured\n(C)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Cured\n(C)]]","v":0},{"$f":"SUM(R30:T30)","v":0}]
[null,"Notes: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Treatment Completed",{"$f":"AggTreatmentP1[[#Totals],[ Completed\nTreatment\n(CTD)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[ Completed\nTreatment\n(CTD)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[ Completed\nTreatment\n(CTD)]]","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Treatment Failed",{"$f":"AggTreatmentP1[[#Totals],[Treatment Failed\n(F)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Treatment Failed\n(F)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Treatment Failed\n(F)]]","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Died",{"$f":"AggTreatmentP1[[#Totals],[Died\n(D)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Died\n(D)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Died\n(D)]]","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lost to Follow-up",{"$f":"AggTreatmentP1[[#Totals],[Lost to Follow-up\n(L)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Lost to Follow-up\n(L)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Lost to Follow-up\n(L)]]","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Evaluated",{"$f":"AggTreatmentP1[[#Totals],[Not Evaluated\n(NT)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Not Evaluated\n(NT)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Not Evaluated\n(NT)]]","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transferred Out",{"$f":"AggTreatmentP1[[#Totals],[Transferred Out]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Transferred Out]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Transferred Out]]","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HIV Status"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Positive",{"$f":"AggTreatmentP1[[#Totals],[Known HIV Positive (KPos)]]+AggTreatmentP1[[#Totals],[Newly Tested HIV Positive (NPos)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Known HIV Positive (KPos)]]+AggTreatmentP1[[#Totals],[Newly Tested HIV Positive (NPos)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Known HIV Positive (KPos)]]+AggTreatmentP1[[#Totals],[Newly Tested HIV Positive (NPos)]]","v":0},{"$f":"SUM(R38:T38)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Negative",{"$f":"AggTreatmentP1[[#Totals],[Negative (Neg)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Negative (Neg)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Negative (Neg)]]","v":0},{"$f":"SUM(R39:T39)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unknown",{"$f":"AggTreatmentP1[[#Totals],[Unknown (Unk)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Unknown (Unk)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Unknown (Unk)]]","v":0},{"$f":"SUM(R40:T40)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HIV Care Provided"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"On ART",{"$f":"AggTreatmentP1[[#Totals],[Enrolled in ART]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Enrolled in ART]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Enrolled in ART]]","v":0},{"$f":"SUM(R42:T42)","v":0}]

{"sheet":"4. DATA QUALITY ANALYSIS","index":4,"n_rows":29,"n_cols":37,"rows_kept":29,"cut":false,"hidden":false,"merged":[[4,8,4,10],[4,11,4,13],[4,14,4,16],[4,17,4,19],[11,4,11,5],[3,2,3,5],[4,2,4,5],[6,1,6,5],[2,2,2,5],[2,1,4,1],[30,2,30,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[23,4,23,5],[27,3,27,5],[28,3,28,5],[25,3,25,5],[26,3,26,5],[2,21,2,24],[2,25,2,28],[2,29,2,32],[2,33,2,36],[29,2,29,5],[15,4,15,5],[16,4,16,5],[18,4,18,5],[19,1,19,3],[7,1,7,5],[14,1,14,3],[12,4,12,5],[13,4,13,5],[17,4,17,5],[9,1,9,3],[10,4,10,5]]}
[null,"DATA AGREEMENT ANALYSIS (PATIENT-LEVEL)"]
[]
[null,"Color Legend: ","Presumptive TB Register",null,null,null,null,"Patient-level data is auto-populated from data entry cells on PL data entry tabs. Blank cells indicate no data collected during abstraction. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sex: Agreement between sources",null,null,null,"Age: Agreement between sources",null,null,null,"NAAT Result: Agreement between sources",null,null,null,"HIV Status: Agreement between sources"]
[null,null,"Lab Register"]
[null,null,"TB Treatment Register",null,null,null,null,null,"Sex ",null,null,"Age",null,null,"NAAT Result",null,null,"HIV Status"]
[null,null,null,null,null,null,null,"Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10","Column11","Column12","Column13"]
[null,"AGREEMENT SUMMARY",null,null,null,null,null,"P1",{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!D14","v":0},{"$f":"'6b. LAB REGISTER - PL'!D11","v":0},{"$f":"'7b. TB TX REGISTER - PL'!F9","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!E14","v":0},{"$f":"'6b. LAB REGISTER - PL'!E11","v":0},{"$f":"'7b. TB TX REGISTER - PL'!G9","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!M14","v":0},{"$f":"'6b. LAB REGISTER - PL'!N11","v":0},{"$f":"'7b. TB TX REGISTER - PL'!L9","v":0},{"$f":"IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O14=\"Positive\",'5b. PRESUMPTIVE REGISTER -  PL'!P14=\"Positive\"),\"Positive\",IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O14=\"Negative\",'5b. PRESUMPTIVE REGISTER -  PL'!P14=\"Negative\"),\"Negative\",IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!O14=\"Blank\",'5b. PRESUMPTIVE REGISTER -  PL'!P14=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"IF(OR('6b. LAB REGISTER - PL'!F11=\"Positive\",'6b. LAB REGISTER - PL'!G11=\"Positive\"),\"Positive\",IF(OR('6b. LAB REGISTER - PL'!F11=\"Negative\",'6b. LAB REGISTER - PL'!G11=\"Negative\"),\"Negative\",IF(AND('6b. LAB REGISTER - PL'!F11=\"Blank\", '6b. LAB REGISTER - PL'!G11=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"'7b. TB TX REGISTER - PL'!R9","v":0},"P1",{"$f":"IF(AND(I7<>0,J7<>0,I7=J7),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AND(I7<>0,K7<>0,I7=K7),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AND(J7<>0,K7<>0,J7=K7),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AND(I7<>0,J7<>0,K7<>0,I7=J7,I7=K7,J7=K7),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AND(L7<>0,M7<>0,L7=M7),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AND(L7<>0,N7<>0,L7=N7),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AND(M7<>0,N7<>0,M7=N7),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AND(L7<>0,M7<>0,N7<>0,L7=M7,M7=N7,L7=N7),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AND(O7<>0,P7<>0,O7=P7),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AND(O7<>0,Q7<>0,O7=Q7),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AND(P7<>0,Q7<>0,P7=Q7),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AND(O7<>0,P7<>0,Q7<>0,O7=P7,O7=Q7,P7=Q7),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AND(R7<>\"0\",S7<>\"0\",R7=S7),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AND(R7<>\"0\",T7<>0,R7=T7),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AND(S7<>\"0\",T7<>0,S7=T7),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AND(R7<>0,S7<>0,T7<>0,R7=S7,S7=T7,R7=T7),\"Yes\",\"No\")","v":"No"}]
[null,"(Calculated only for patients found in respective registers)",null,null,null,null,null,"P2",{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!D15","v":0},{"$f":"'6b. LAB REGISTER - PL'!D12","v":0},{"$f":"'7b. TB TX REGISTER - PL'!F10","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!E15","v":0},{"$f":"'6b. LAB REGISTER - PL'!E12","v":0},{"$f":"'7b. TB TX REGISTER - PL'!G10","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!M15","v":0},{"$f":"'6b. LAB REGISTER - PL'!N12","v":0},{"$f":"'7b. TB TX REGISTER - PL'!L10","v":0},{"$f":"IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O15=\"Positive\",'5b. PRESUMPTIVE REGISTER -  PL'!P15=\"Positive\"),\"Positive\",IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O15=\"Negative\",'5b. PRESUMPTIVE REGISTER -  PL'!P15=\"Negative\"),\"Negative\",IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!O15=\"Blank\",'5b. PRESUMPTIVE REGISTER -  PL'!P15=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"IF(OR('6b. LAB REGISTER - PL'!F12=\"Positive\",'6b. LAB REGISTER - PL'!G12=\"Positive\"),\"Positive\",IF(OR('6b. LAB REGISTER - PL'!F12=\"Negative\",'6b. LAB REGISTER - PL'!G12=\"Negative\"),\"Negative\",IF(AND('6b. LAB REGISTER - PL'!F12=\"Blank\", '6b. LAB REGISTER - PL'!G12=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"'7b. TB TX REGISTER - PL'!R10","v":"Negative"},"P2","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,null,null,null,null,null,null,"P3",{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!D16","v":0},{"$f":"'6b. LAB REGISTER - PL'!D13","v":0},{"$f":"'7b. TB TX REGISTER - PL'!F11","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!E16","v":0},{"$f":"'6b. LAB REGISTER - PL'!E13","v":0},{"$f":"'7b. TB TX REGISTER - PL'!G11","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!M16","v":0},{"$f":"'6b. LAB REGISTER - PL'!N13","v":0},{"$f":"'7b. TB TX REGISTER - PL'!L11","v":0},{"$f":"IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O16=\"Positive\",'5b. PRESUMPTIVE REGISTER -  PL'!P16=\"Positive\"),\"Positive\",IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O16=\"Negative\",'5b. PRESUMPTIVE REGISTER -  PL'!P16=\"Negative\"),\"Negative\",IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!O16=\"Blank\",'5b. PRESUMPTIVE REGISTER -  PL'!P16=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"IF(OR('6b. LAB REGISTER - PL'!F13=\"Positive\",'6b. LAB REGISTER - PL'!G13=\"Positive\"),\"Positive\",IF(OR('6b. LAB REGISTER - PL'!F13=\"Negative\",'6b. LAB REGISTER - PL'!G13=\"Negative\"),\"Negative\",IF(AND('6b. LAB REGISTER - PL'!F13=\"Blank\", '6b. LAB REGISTER - PL'!G13=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"'7b. TB TX REGISTER - PL'!R11","v":"Negative"},"P3","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"Presumptive TB Register / Lab Register",null,null,null,null,null,"P4",{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!D17","v":0},{"$f":"'6b. LAB REGISTER - PL'!D14","v":0},{"$f":"'7b. TB TX REGISTER - PL'!F12","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!E17","v":0},{"$f":"'6b. LAB REGISTER - PL'!E14","v":0},{"$f":"'7b. TB TX REGISTER - PL'!G12","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!M17","v":0},{"$f":"'6b. LAB REGISTER - PL'!N14","v":0},{"$f":"'7b. TB TX REGISTER - PL'!L12","v":0},{"$f":"IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O17=\"Positive\",'5b. PRESUMPTIVE REGISTER -  PL'!P17=\"Positive\"),\"Positive\",IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O17=\"Negative\",'5b. PRESUMPTIVE REGISTER -  PL'!P17=\"Negative\"),\"Negative\",IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!O17=\"Blank\",'5b. PRESUMPTIVE REGISTER -  PL'!P17=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"IF(OR('6b. LAB REGISTER - PL'!F14=\"Positive\",'6b. LAB REGISTER - PL'!G14=\"Positive\"),\"Positive\",IF(OR('6b. LAB REGISTER - PL'!F14=\"Negative\",'6b. LAB REGISTER - PL'!G14=\"Negative\"),\"Negative\",IF(AND('6b. LAB REGISTER - PL'!F14=\"Blank\", '6b. LAB REGISTER - PL'!G14=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"'7b. TB TX REGISTER - PL'!R12","v":"Negative"},"P4","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"   Sex",null,null,{"$f":"(COUNTIFS(V7:V26,\"Yes\"))/(COUNTIFS('6b. LAB REGISTER - PL'!C11:C30,\"Yes\"))","v":{"$error":"#DIV/0!"}},null,null,"P5",{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!D18","v":0},{"$f":"'6b. LAB REGISTER - PL'!D15","v":0},{"$f":"'7b. TB TX REGISTER - PL'!F13","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!E18","v":0},{"$f":"'6b. LAB REGISTER - PL'!E15","v":0},{"$f":"'7b. TB TX REGISTER - PL'!G13","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!M18","v":0},{"$f":"'6b. LAB REGISTER - PL'!N15","v":0},{"$f":"'7b. TB TX REGISTER - PL'!L13","v":0},{"$f":"IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O18=\"Positive\",'5b. PRESUMPTIVE REGISTER -  PL'!P18=\"Positive\"),\"Positive\",IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O18=\"Negative\",'5b. PRESUMPTIVE REGISTER -  PL'!P18=\"Negative\"),\"Negative\",IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!O18=\"Blank\",'5b. PRESUMPTIVE REGISTER -  PL'!P18=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"IF(OR('6b. LAB REGISTER - PL'!F15=\"Positive\",'6b. LAB REGISTER - PL'!G15=\"Positive\"),\"Positive\",IF(OR('6b. LAB REGISTER - PL'!F15=\"Negative\",'6b. LAB REGISTER - PL'!G15=\"Negative\"),\"Negative\",IF(AND('6b. LAB REGISTER - PL'!F15=\"Blank\", '6b. LAB REGISTER - PL'!G15=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"'7b. TB TX REGISTER - PL'!R13","v":"Unknown"},"P5","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"   Age",null,null,{"$f":"COUNTIFS(Z7:Z26,\"Yes\")/(COUNTIFS('6b. LAB REGISTER - PL'!C11:C30,\"Yes\"))","v":{"$error":"#DIV/0!"}},null,null,"P6",{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!D19","v":0},{"$f":"'6b. LAB REGISTER - PL'!D16","v":0},{"$f":"'7b. TB TX REGISTER - PL'!F14","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!E19","v":0},{"$f":"'6b. LAB REGISTER - PL'!E16","v":0},{"$f":"'7b. TB TX REGISTER - PL'!G14","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!M19","v":0},{"$f":"'6b. LAB REGISTER - PL'!N16","v":0},{"$f":"'7b. TB TX REGISTER - PL'!L14","v":0},{"$f":"IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O19=\"Positive\",'5b. PRESUMPTIVE REGISTER -  PL'!P19=\"Positive\"),\"Positive\",IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O19=\"Negative\",'5b. PRESUMPTIVE REGISTER -  PL'!P19=\"Negative\"),\"Negative\",IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!O19=\"Blank\",'5b. PRESUMPTIVE REGISTER -  PL'!P19=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"IF(OR('6b. LAB REGISTER - PL'!F16=\"Positive\",'6b. LAB REGISTER - PL'!G16=\"Positive\"),\"Positive\",IF(OR('6b. LAB REGISTER - PL'!F16=\"Negative\",'6b. LAB REGISTER - PL'!G16=\"Negative\"),\"Negative\",IF(AND('6b. LAB REGISTER - PL'!F16=\"Blank\", '6b. LAB REGISTER - PL'!G16=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"'7b. TB TX REGISTER - PL'!R14","v":"Positive"},"P6","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"   NAAT Result",null,null,{"$f":"COUNTIFS(AD7:AD26,\"Yes\")/(COUNTIFS('6b. LAB REGISTER - PL'!C11:C30,\"Yes\"))","v":{"$error":"#DIV/0!"}},null,null,"P7",{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!D20","v":0},{"$f":"'6b. LAB REGISTER - PL'!D17","v":0},{"$f":"'7b. TB TX REGISTER - PL'!F15","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!E20","v":0},{"$f":"'6b. LAB REGISTER - PL'!E17","v":0},{"$f":"'7b. TB TX REGISTER - PL'!G15","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!M20","v":0},{"$f":"'6b. LAB REGISTER - PL'!N17","v":0},{"$f":"'7b. TB TX REGISTER - PL'!L15","v":0},{"$f":"IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O20=\"Positive\",'5b. PRESUMPTIVE REGISTER -  PL'!P20=\"Positive\"),\"Positive\",IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O20=\"Negative\",'5b. PRESUMPTIVE REGISTER -  PL'!P20=\"Negative\"),\"Negative\",IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!O20=\"Blank\",'5b. PRESUMPTIVE REGISTER -  PL'!P20=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"IF(OR('6b. LAB REGISTER - PL'!F17=\"Positive\",'6b. LAB REGISTER - PL'!G17=\"Positive\"),\"Positive\",IF(OR('6b. LAB REGISTER - PL'!F17=\"Negative\",'6b. LAB REGISTER - PL'!G17=\"Negative\"),\"Negative\",IF(AND('6b. LAB REGISTER - PL'!F17=\"Blank\", '6b. LAB REGISTER - PL'!G17=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"'7b. TB TX REGISTER - PL'!R15","v":"Negative"},"P7","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"   HIV Status",null,null,{"$f":"COUNTIFS(AH7:AH26,\"Yes\")/(COUNTIFS('6b. LAB REGISTER - PL'!C11:C30,\"Yes\"))","v":{"$error":"#DIV/0!"}},null,null,"P8",{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!D21","v":0},{"$f":"'6b. LAB REGISTER - PL'!D18","v":0},{"$f":"'7b. TB TX REGISTER - PL'!F16","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!E21","v":0},{"$f":"'6b. LAB REGISTER - PL'!E18","v":0},{"$f":"'7b. TB TX REGISTER - PL'!G16","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!M21","v":0},{"$f":"'6b. LAB REGISTER - PL'!N18","v":0},{"$f":"'7b. TB TX REGISTER - PL'!L16","v":0},{"$f":"IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O21=\"Positive\",'5b. PRESUMPTIVE REGISTER -  PL'!P21=\"Positive\"),\"Positive\",IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O21=\"Negative\",'5b. PRESUMPTIVE REGISTER -  PL'!P21=\"Negative\"),\"Negative\",IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!O21=\"Blank\",'5b. PRESUMPTIVE REGISTER -  PL'!P21=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"IF(OR('6b. LAB REGISTER - PL'!F18=\"Positive\",'6b. LAB REGISTER - PL'!G18=\"Positive\"),\"Positive\",IF(OR('6b. LAB REGISTER - PL'!F18=\"Negative\",'6b. LAB REGISTER - PL'!G18=\"Negative\"),\"Negative\",IF(AND('6b. LAB REGISTER - PL'!F18=\"Blank\", '6b. LAB REGISTER - PL'!G18=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"'7b. TB TX REGISTER - PL'!R16","v":"Negative"},"P8","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"Presumptive TB Register / TB Treatment Register",null,null,null,null,null,"P9",{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!D22","v":0},{"$f":"'6b. LAB REGISTER - PL'!D19","v":0},{"$f":"'7b. TB TX REGISTER - PL'!F17","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!E22","v":0},{"$f":"'6b. LAB REGISTER - PL'!E19","v":0},{"$f":"'7b. TB TX REGISTER - PL'!G17","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!M22","v":0},{"$f":"'6b. LAB REGISTER - PL'!N19","v":0},{"$f":"'7b. TB TX REGISTER - PL'!L17","v":0},{"$f":"IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O22=\"Positive\",'5b. PRESUMPTIVE REGISTER -  PL'!P22=\"Positive\"),\"Positive\",IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O22=\"Negative\",'5b. PRESUMPTIVE REGISTER -  PL'!P22=\"Negative\"),\"Negative\",IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!O22=\"Blank\",'5b. PRESUMPTIVE REGISTER -  PL'!P22=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"IF(OR('6b. LAB REGISTER - PL'!F19=\"Positive\",'6b. LAB REGISTER - PL'!G19=\"Positive\"),\"Positive\",IF(OR('6b. LAB REGISTER - PL'!F19=\"Negative\",'6b. LAB REGISTER - PL'!G19=\"Negative\"),\"Negative\",IF(AND('6b. LAB REGISTER - PL'!F19=\"Blank\", '6b. LAB REGISTER - PL'!G19=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"'7b. TB TX REGISTER - PL'!R17","v":"Negative"},"P9","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"   Sex",null,null,{"$f":"COUNTIFS(W7:W26,\"Yes\")/(COUNTIFS('7b. TB TX REGISTER - PL'!C9:C28,\"Yes\"))","v":{"$error":"#DIV/0!"}},null,null,"P10",{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!D23","v":0},{"$f":"'6b. LAB REGISTER - PL'!D20","v":0},{"$f":"'7b. TB TX REGISTER - PL'!F18","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!E23","v":0},{"$f":"'6b. LAB REGISTER - PL'!E20","v":0},{"$f":"'7b. TB TX REGISTER - PL'!G18","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!M23","v":0},{"$f":"'6b. LAB REGISTER - PL'!N20","v":0},{"$f":"'7b. TB TX REGISTER - PL'!L18","v":0},{"$f":"IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O23=\"Positive\",'5b. PRESUMPTIVE REGISTER -  PL'!P23=\"Positive\"),\"Positive\",IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O23=\"Negative\",'5b. PRESUMPTIVE REGISTER -  PL'!P23=\"Negative\"),\"Negative\",IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!O23=\"Blank\",'5b. PRESUMPTIVE REGISTER -  PL'!P23=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"IF(OR('6b. LAB REGISTER - PL'!F20=\"Positive\",'6b. LAB REGISTER - PL'!G20=\"Positive\"),\"Positive\",IF(OR('6b. LAB REGISTER - PL'!F20=\"Negative\",'6b. LAB REGISTER - PL'!G20=\"Negative\"),\"Negative\",IF(AND('6b. LAB REGISTER - PL'!F20=\"Blank\", '6b. LAB REGISTER - PL'!G20=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"'7b. TB TX REGISTER - PL'!R18","v":"Negative"},"P10","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"   Age",null,null,{"$f":"COUNTIFS(AA7:AA26,\"Yes\")/(COUNTIFS('7b. TB TX REGISTER - PL'!C9:C28,\"Yes\"))","v":{"$error":"#DIV/0!"}},null,null,"P11",{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!D24","v":0},{"$f":"'6b. LAB REGISTER - PL'!D21","v":0},{"$f":"'7b. TB TX REGISTER - PL'!F19","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!E24","v":0},{"$f":"'6b. LAB REGISTER - PL'!E21","v":0},{"$f":"'7b. TB TX REGISTER - PL'!G19","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!M24","v":0},{"$f":"'6b. LAB REGISTER - PL'!N21","v":0},{"$f":"'7b. TB TX REGISTER - PL'!L19","v":0},{"$f":"IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O24=\"Positive\",'5b. PRESUMPTIVE REGISTER -  PL'!P24=\"Positive\"),\"Positive\",IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O24=\"Negative\",'5b. PRESUMPTIVE REGISTER -  PL'!P24=\"Negative\"),\"Negative\",IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!O24=\"Blank\",'5b. PRESUMPTIVE REGISTER -  PL'!P24=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"IF(OR('6b. LAB REGISTER - PL'!F21=\"Positive\",'6b. LAB REGISTER - PL'!G21=\"Positive\"),\"Positive\",IF(OR('6b. LAB REGISTER - PL'!F21=\"Negative\",'6b. LAB REGISTER - PL'!G21=\"Negative\"),\"Negative\",IF(AND('6b. LAB REGISTER - PL'!F21=\"Blank\", '6b. LAB REGISTER - PL'!G21=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"'7b. TB TX REGISTER - PL'!R19","v":0},"P11","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"   NAAT Result",null,null,{"$f":"COUNTIFS(AE7:AE26,\"Yes\")/(COUNTIFS('7b. TB TX REGISTER - PL'!C9:C28,\"Yes\"))","v":{"$error":"#DIV/0!"}},null,null,"P12",{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!D25","v":0},{"$f":"'6b. LAB REGISTER - PL'!D22","v":0},{"$f":"'7b. TB TX REGISTER - PL'!F20","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!E25","v":0},{"$f":"'6b. LAB REGISTER - PL'!E22","v":0},{"$f":"'7b. TB TX REGISTER - PL'!G20","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!M25","v":0},{"$f":"'6b. LAB REGISTER - PL'!N22","v":0},{"$f":"'7b. TB TX REGISTER - PL'!L20","v":0},{"$f":"IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O25=\"Positive\",'5b. PRESUMPTIVE REGISTER -  PL'!P25=\"Positive\"),\"Positive\",IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O25=\"Negative\",'5b. PRESUMPTIVE REGISTER -  PL'!P25=\"Negative\"),\"Negative\",IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!O25=\"Blank\",'5b. PRESUMPTIVE REGISTER -  PL'!P25=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"IF(OR('6b. LAB REGISTER - PL'!F22=\"Positive\",'6b. LAB REGISTER - PL'!G22=\"Positive\"),\"Positive\",IF(OR('6b. LAB REGISTER - PL'!F22=\"Negative\",'6b. LAB REGISTER - PL'!G22=\"Negative\"),\"Negative\",IF(AND('6b. LAB REGISTER - PL'!F22=\"Blank\", '6b. LAB REGISTER - PL'!G22=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"'7b. TB TX REGISTER - PL'!R20","v":0},"P12","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"   HIV Status",null,null,{"$f":"COUNTIFS(AI7:AI26,\"Yes\")/(COUNTIFS('7b. TB TX REGISTER - PL'!C9:C28,\"Yes\"))","v":{"$error":"#DIV/0!"}},null,null,"P13",{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!D26","v":0},{"$f":"'6b. LAB REGISTER - PL'!D23","v":0},{"$f":"'7b. TB TX REGISTER - PL'!F21","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!E26","v":0},{"$f":"'6b. LAB REGISTER - PL'!E23","v":0},{"$f":"'7b. TB TX REGISTER - PL'!G21","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!M26","v":0},{"$f":"'6b. LAB REGISTER - PL'!N23","v":0},{"$f":"'7b. TB TX REGISTER - PL'!L21","v":0},{"$f":"IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O26=\"Positive\",'5b. PRESUMPTIVE REGISTER -  PL'!P26=\"Positive\"),\"Positive\",IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O26=\"Negative\",'5b. PRESUMPTIVE REGISTER -  PL'!P26=\"Negative\"),\"Negative\",IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!O26=\"Blank\",'5b. PRESUMPTIVE REGISTER -  PL'!P26=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"IF(OR('6b. LAB REGISTER - PL'!F23=\"Positive\",'6b. LAB REGISTER - PL'!G23=\"Positive\"),\"Positive\",IF(OR('6b. LAB REGISTER - PL'!F23=\"Negative\",'6b. LAB REGISTER - PL'!G23=\"Negative\"),\"Negative\",IF(AND('6b. LAB REGISTER - PL'!F23=\"Blank\", '6b. LAB REGISTER - PL'!G23=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"'7b. TB TX REGISTER - PL'!R21","v":0},"P13","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"Lab Register / TB Treatment Register",null,null,null,null,null,"P14",{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!D27","v":0},{"$f":"'6b. LAB REGISTER - PL'!D24","v":0},{"$f":"'7b. TB TX REGISTER - PL'!F22","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!E27","v":0},{"$f":"'6b. LAB REGISTER - PL'!E24","v":0},{"$f":"'7b. TB TX REGISTER - PL'!G22","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!M27","v":0},{"$f":"'6b. LAB REGISTER - PL'!N24","v":0},{"$f":"'7b. TB TX REGISTER - PL'!L22","v":0},{"$f":"IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O27=\"Positive\",'5b. PRESUMPTIVE REGISTER -  PL'!P27=\"Positive\"),\"Positive\",IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O27=\"Negative\",'5b. PRESUMPTIVE REGISTER -  PL'!P27=\"Negative\"),\"Negative\",IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!O27=\"Blank\",'5b. PRESUMPTIVE REGISTER -  PL'!P27=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"IF(OR('6b. LAB REGISTER - PL'!F24=\"Positive\",'6b. LAB REGISTER - PL'!G24=\"Positive\"),\"Positive\",IF(OR('6b. LAB REGISTER - PL'!F24=\"Negative\",'6b. LAB REGISTER - PL'!G24=\"Negative\"),\"Negative\",IF(AND('6b. LAB REGISTER - PL'!F24=\"Blank\", '6b. LAB REGISTER - PL'!G24=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"'7b. TB TX REGISTER - PL'!R22","v":0},"P14","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"   Sex ",null,null,{"$f":"COUNTIFS(X7:X26,\"Yes\")/(COUNTIFS('7b. TB TX REGISTER - PL'!C9:C28,\"Yes\"))","v":{"$error":"#DIV/0!"}},null,null,"P15",{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!D28","v":0},{"$f":"'6b. LAB REGISTER - PL'!D25","v":0},{"$f":"'7b. TB TX REGISTER - PL'!F23","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!E28","v":0},{"$f":"'6b. LAB REGISTER - PL'!E25","v":0},{"$f":"'7b. TB TX REGISTER - PL'!G23","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!M28","v":0},{"$f":"'6b. LAB REGISTER - PL'!N25","v":0},{"$f":"'7b. TB TX REGISTER - PL'!L23","v":0},{"$f":"IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O28=\"Positive\",'5b. PRESUMPTIVE REGISTER -  PL'!P28=\"Positive\"),\"Positive\",IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O28=\"Negative\",'5b. PRESUMPTIVE REGISTER -  PL'!P28=\"Negative\"),\"Negative\",IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!O28=\"Blank\",'5b. PRESUMPTIVE REGISTER -  PL'!P28=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"IF(OR('6b. LAB REGISTER - PL'!F25=\"Positive\",'6b. LAB REGISTER - PL'!G25=\"Positive\"),\"Positive\",IF(OR('6b. LAB REGISTER - PL'!F25=\"Negative\",'6b. LAB REGISTER - PL'!G25=\"Negative\"),\"Negative\",IF(AND('6b. LAB REGISTER - PL'!F25=\"Blank\", '6b. LAB REGISTER - PL'!G25=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"'7b. TB TX REGISTER - PL'!R23","v":0},"P15","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"   Age",null,null,{"$f":"COUNTIFS(AB7:AB26,\"Yes\")/(COUNTIFS('7b. TB TX REGISTER - PL'!C9:C28,\"Yes\"))","v":{"$error":"#DIV/0!"}},null,null,"P16",{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!D29","v":0},{"$f":"'6b. LAB REGISTER - PL'!D26","v":0},{"$f":"'7b. TB TX REGISTER - PL'!F24","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!E29","v":0},{"$f":"'6b. LAB REGISTER - PL'!E26","v":0},{"$f":"'7b. TB TX REGISTER - PL'!G24","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!M29","v":0},{"$f":"'6b. LAB REGISTER - PL'!N26","v":0},{"$f":"'7b. TB TX REGISTER - PL'!L24","v":0},{"$f":"IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O29=\"Positive\",'5b. PRESUMPTIVE REGISTER -  PL'!P29=\"Positive\"),\"Positive\",IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O29=\"Negative\",'5b. PRESUMPTIVE REGISTER -  PL'!P29=\"Negative\"),\"Negative\",IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!O29=\"Blank\",'5b. PRESUMPTIVE REGISTER -  PL'!P29=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"IF(OR('6b. LAB REGISTER - PL'!F26=\"Positive\",'6b. LAB REGISTER - PL'!G26=\"Positive\"),\"Positive\",IF(OR('6b. LAB REGISTER - PL'!F26=\"Negative\",'6b. LAB REGISTER - PL'!G26=\"Negative\"),\"Negative\",IF(AND('6b. LAB REGISTER - PL'!F26=\"Blank\", '6b. LAB REGISTER - PL'!G26=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"'7b. TB TX REGISTER - PL'!R24","v":0},"P16","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"   Xpert MTB/RIF Result",null,null,{"$f":"COUNTIFS(AF7:AF26,\"Yes\")/(COUNTIFS('7b. TB TX REGISTER - PL'!C9:C28,\"Yes\"))","v":{"$error":"#DIV/0!"}},null,null,"P17",{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!D30","v":0},{"$f":"'6b. LAB REGISTER - PL'!D27","v":0},{"$f":"'7b. TB TX REGISTER - PL'!F25","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!E30","v":0},{"$f":"'6b. LAB REGISTER - PL'!E27","v":0},{"$f":"'7b. TB TX REGISTER - PL'!G25","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!M30","v":0},{"$f":"'6b. LAB REGISTER - PL'!N27","v":0},{"$f":"'7b. TB TX REGISTER - PL'!L25","v":0},{"$f":"IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O30=\"Positive\",'5b. PRESUMPTIVE REGISTER -  PL'!P30=\"Positive\"),\"Positive\",IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O30=\"Negative\",'5b. PRESUMPTIVE REGISTER -  PL'!P30=\"Negative\"),\"Negative\",IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!O30=\"Blank\",'5b. PRESUMPTIVE REGISTER -  PL'!P30=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"IF(OR('6b. LAB REGISTER - PL'!F27=\"Positive\",'6b. LAB REGISTER - PL'!G27=\"Positive\"),\"Positive\",IF(OR('6b. LAB REGISTER - PL'!F27=\"Negative\",'6b. LAB REGISTER - PL'!G27=\"Negative\"),\"Negative\",IF(AND('6b. LAB REGISTER - PL'!F27=\"Blank\", '6b. LAB REGISTER - PL'!G27=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"'7b. TB TX REGISTER - PL'!R25","v":0},"P17","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"   HIV Status",null,null,{"$f":"COUNTIFS(AJ7:AJ26,\"Yes\")/(COUNTIFS('7b. TB TX REGISTER - PL'!C9:C28,\"Yes\"))","v":{"$error":"#DIV/0!"}},null,null,"P18",{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!D31","v":0},{"$f":"'6b. LAB REGISTER - PL'!D28","v":0},{"$f":"'7b. TB TX REGISTER - PL'!F26","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!E31","v":0},{"$f":"'6b. LAB REGISTER - PL'!E28","v":0},{"$f":"'7b. TB TX REGISTER - PL'!G26","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!M31","v":0},{"$f":"'6b. LAB REGISTER - PL'!N28","v":0},{"$f":"'7b. TB TX REGISTER - PL'!L26","v":0},{"$f":"IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O31=\"Positive\",'5b. PRESUMPTIVE REGISTER -  PL'!P31=\"Positive\"),\"Positive\",IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O31=\"Negative\",'5b. PRESUMPTIVE REGISTER -  PL'!P31=\"Negative\"),\"Negative\",IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!O31=\"Blank\",'5b. PRESUMPTIVE REGISTER -  PL'!P31=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"IF(OR('6b. LAB REGISTER - PL'!F28=\"Positive\",'6b. LAB REGISTER - PL'!G28=\"Positive\"),\"Positive\",IF(OR('6b. LAB REGISTER - PL'!F28=\"Negative\",'6b. LAB REGISTER - PL'!G28=\"Negative\"),\"Negative\",IF(AND('6b. LAB REGISTER - PL'!F28=\"Blank\", '6b. LAB REGISTER - PL'!G28=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"'7b. TB TX REGISTER - PL'!R26","v":0},"P18","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"Overall ",null,null,null,null,null,"P19",{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!D32","v":0},{"$f":"'6b. LAB REGISTER - PL'!D29","v":0},{"$f":"'7b. TB TX REGISTER - PL'!F27","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!E32","v":0},{"$f":"'6b. LAB REGISTER - PL'!E29","v":0},{"$f":"'7b. TB TX REGISTER - PL'!G27","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!M32","v":0},{"$f":"'6b. LAB REGISTER - PL'!N29","v":0},{"$f":"'7b. TB TX REGISTER - PL'!L27","v":0},{"$f":"IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O32=\"Positive\",'5b. PRESUMPTIVE REGISTER -  PL'!P32=\"Positive\"),\"Positive\",IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!O32=\"Negative\",'5b. PRESUMPTIVE REGISTER -  PL'!P32=\"Negative\"),\"Negative\",IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!O32=\"Blank\",'5b. PRESUMPTIVE REGISTER -  PL'!P32=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"IF(OR('6b. LAB REGISTER - PL'!F29=\"Positive\",'6b. LAB REGISTER - PL'!G29=\"Positive\"),\"Positive\",IF(OR('6b. LAB REGISTER - PL'!F29=\"Negative\",'6b. LAB REGISTER - PL'!G29=\"Negative\"),\"Negative\",IF(AND('6b. LAB REGISTER - PL'!F29=\"Blank\", '6b. LAB REGISTER - PL'!G29=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"'7b. TB TX REGISTER - PL'!R27","v":0},"P19","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"   Sex",null,{"$f":"(COUNTIFS(Y7:Y26,\"Yes\"))/(COUNTIFS('7b. TB TX REGISTER - PL'!C9:C28,\"Yes\"))","v":{"$error":"#DIV/0!"}},null,null,null,"P20",{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!#REF!","v":{"$error":"#REF!"}},{"$f":"'6b. LAB REGISTER - PL'!D30","v":0},{"$f":"'7b. TB TX REGISTER - PL'!F28","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!#REF!","v":{"$error":"#REF!"}},{"$f":"'6b. LAB REGISTER - PL'!E30","v":0},{"$f":"'7b. TB TX REGISTER - PL'!G28","v":0},{"$f":"'5b. PRESUMPTIVE REGISTER -  PL'!#REF!","v":{"$error":"#REF!"}},{"$f":"'6b. LAB REGISTER - PL'!N30","v":0},{"$f":"'7b. TB TX REGISTER - PL'!L28","v":0},{"$f":"IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!#REF!=\"Positive\",'5b. PRESUMPTIVE REGISTER -  PL'!#REF!=\"Positive\"),\"Positive\",IF(OR('5b. PRESUMPTIVE REGISTER -  PL'!#REF!=\"Negative\",'5b. PRESUMPTIVE REGISTER -  PL'!#REF!=\"Negative\"),\"Negative\",IF(AND('5b. PRESUMPTIVE REGISTER -  PL'!#REF!=\"Blank\",'5b. PRESUMPTIVE REGISTER -  PL'!#REF!=\"Blank\"),\"Blank\",\"0\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR('6b. LAB REGISTER - PL'!F30=\"Positive\",'6b. LAB REGISTER - PL'!G30=\"Positive\"),\"Positive\",IF(OR('6b. LAB REGISTER - PL'!F30=\"Negative\",'6b. LAB REGISTER - PL'!G30=\"Negative\"),\"Negative\",IF(AND('6b. LAB REGISTER - PL'!F30=\"Blank\", '6b. LAB REGISTER - PL'!G30=\"Blank\"),\"Blank\",\"0\")))","v":"0"},{"$f":"'7b. TB TX REGISTER - PL'!R28","v":0},"P20",{"$error":"#REF!"},{"$error":"#REF!"},"No",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"No",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"No",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"No",{"$error":"#REF!"}]
[null,"   Age",null,{"$f":"(COUNTIFS(AC7:AC26,\"Yes\"))/(COUNTIFS('7b. TB TX REGISTER - PL'!C9:C28, \"Yes\"))","v":{"$error":"#DIV/0!"}}]
[null,"   NAAT Result",null,{"$f":"(COUNTIFS(AG7:AG26,\"Yes\"))/(COUNTIFS('7b. TB TX REGISTER - PL'!C9:C28, \"Yes\"))","v":{"$error":"#DIV/0!"}}]
[null,"   HIV Status",null,{"$f":"(COUNTIFS(AK7:AK26,\"Yes\"))/(COUNTIFS('7b. TB TX REGISTER - PL'!C9:C28, \"Yes\"))","v":{"$error":"#DIV/0!"}}]

{"sheet":"5a. PRESUMPTIVE REGISTER - AGG","index":5,"n_rows":103,"n_cols":22,"rows_kept":103,"cut":false,"hidden":false,"merged":[[2,1,2,15],[3,1,3,15],[4,1,4,15],[5,1,5,15],[6,1,6,15],[10,0,36,0],[10,11,10,13],[10,14,10,18],[10,19,10,21],[10,8,10,9],[10,3,10,4],[10,5,10,6],[7,1,7,15],[41,3,41,4],[41,5,41,6],[42,3,42,4],[42,5,42,6],[9,11,9,21],[9,8,9,10],[9,3,9,4],[9,5,9,6],[76,0,101,0],[44,0,69,0],[73,3,73,4],[73,5,73,6],[74,3,74,4],[74,5,74,6],[73,8,73,10],[74,8,74,9],[41,8,41,10],[42,8,42,9],[41,11,41,21],[42,11,42,13],[42,14,42,18],[42,19,42,21],[74,19,74,21],[74,11,74,13],[74,14,74,18],[73,11,73,21]]}
["AGGREGATE DATA COLLECTION: PRESUMPTIVE TB REGISTER"]
[]
[null,"Instructions: "]
[null,"   1. Gather Presumptive TB Registers for designated data abstraction period. "]
[null,"   2. Count the page totals for each field and record them here. Each row on this page will represent sums from one page of a register; sections are provided for discrete time periods."]
[null,"Note: "]
[null,"  - Only collect data on entries where the purpose for testing is diagnosis; follow-up tests should not be recorded. "]
[null,"  - Only collect data on entries where the specimen originated from the TB/HIV clinics visited for this assessment. Samples referred from elsewhere should not be recorded. "]
[]
[null,null,null,"(6)",null,"(7)",null,null,"(9)",null,null,"(12)"]
["Time Period One          ***          Time Period One          ***          Time Period One          ***          Time Period One          ***          Time Period One     ***     Time Period One          ***          Time Period One          ***          Time Period One          ***          Time Period One          ***          Time Period One",null,null,"Age",null,"Sex",null,"Specimen","Known HIV Status",null,"Unknown HIV Status","Microscopy",null,null,"NAAT",null,null,null,null,"TB LAM"]
[null,"Register Page #","Total Presumptive TB","Age 0-14","Age 15+ ","Males","Females","Number Specimens Collected","HIV Positive","HIV Negative","Not Tested","Not Done (ND)","AFB (-)","AFB (+)","MTB Not Detected\n(N)","MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)","MTB Detected (including trace), \nRIF Resistance Detected\n(RR)","MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)","Inavlid\nNo Result Error\n(I)","LAM Positive","LAM Negative","Invalid"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,"Total",{"$f":"SUM(AggPresumptiveP1[Total Presumptive TB])","v":0},{"$f":"SUM(AggPresumptiveP1[Age 0-14])","v":0},{"$f":"SUM(AggPresumptiveP1[Age 15+ ])","v":0},{"$f":"SUM(AggPresumptiveP1[Males])","v":0},{"$f":"SUM(AggPresumptiveP1[Females])","v":0},{"$f":"SUM(AggPresumptiveP1[Number Specimens Collected])","v":0},{"$f":"SUM(AggPresumptiveP1[HIV Positive])","v":0},{"$f":"SUM(AggPresumptiveP1[HIV Negative])","v":0},{"$f":"SUM(AggPresumptiveP1[Not Tested])","v":0},{"$f":"SUM(AggPresumptiveP1[Not Done (ND)])","v":0},{"$f":"SUM(AggPresumptiveP1[AFB (-)])","v":0},{"$f":"SUM(AggPresumptiveP1[AFB (+)])","v":0},{"$f":"SUM(AggPresumptiveP1[MTB Not Detected\n(N)])","v":0},{"$f":"SUM(AggPresumptiveP1[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)])","v":0},{"$f":"SUM(AggPresumptiveP1[MTB Detected (including trace), \nRIF Resistance Detected\n(RR)])","v":0},{"$f":"SUM(AggPresumptiveP1[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)])","v":0},{"$f":"SUM(AggPresumptiveP1[Inavlid\nNo Result Error\n(I)])","v":0},{"$f":"SUM(AggPresumptiveP1[LAM Positive])","v":0},{"$f":"SUM(AggPresumptiveP1[LAM Negative])","v":0},{"$f":"SUM(AggPresumptiveP1[Invalid])","v":0}]
[null,"Total",{"$f":"AggPresumptiveP1[[#Totals],[Total Presumptive TB]]","v":0},{"$f":"AggPresumptiveP1[[#Totals],[Age 0-14]]","v":0},{"$f":"AggPresumptiveP1[[#Totals],[Age 15+ ]]","v":0},{"$f":"AggPresumptiveP1[[#Totals],[Males]]","v":0},{"$f":"AggPresumptiveP1[[#Totals],[Females]]","v":0},{"$f":"AggPresumptiveP1[[#Totals],[Number Specimens Collected]]","v":0},{"$f":"AggPresumptiveP1[[#Totals],[HIV Positive]]","v":0},{"$f":"AggPresumptiveP1[[#Totals],[HIV Negative]]","v":0},{"$f":"AggPresumptiveP1[[#Totals],[Not Tested]]","v":0},{"$f":"AggPresumptiveP1[[#Totals],[Not Done (ND)]]","v":0},{"$f":"AggPresumptiveP1[[#Totals],[AFB (-)]]","v":0},{"$f":"AggPresumptiveP1[[#Totals],[AFB (+)]]","v":0},{"$f":"AggPresumptiveP1[[#Totals],[MTB Not Detected\n(N)]]","v":0},{"$f":"AggPresumptiveP1[[#Totals],[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)]]","v":0},{"$f":"AggPresumptiveP1[[#Totals],[MTB Detected (including trace), \nRIF Resistance Detected\n(RR)]]","v":0},{"$f":"AggPresumptiveP1[[#Totals],[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)]]","v":0},{"$f":"AggPresumptiveP1[[#Totals],[Inavlid\nNo Result Error\n(I)]]","v":0},{"$f":"AggPresumptiveP1[[#Totals],[LAM Positive]]","v":0},{"$f":"AggPresumptiveP1[[#Totals],[LAM Negative]]","v":0},{"$f":"AggPresumptiveP1[[#Totals],[Invalid]]","v":0}]
[]
[]
[null,null,null,"(6)",null,"(7)",null,null,"(9)",null,null,"(12)"]
[null,null,null,"Age",null,"Sex",null,"Specimen","Known HIV Status",null,"Unknown HIV Status","Microscopy",null,null,"NAAT",null,null,null,null,"TB LAM"]
["top","Register Page #","Total Presumptive TB","Age 0-14","Age 15+ ","Males","Females","Number Specimens Collected","HIV Positive","HIV Negative","Not Tested","Not Done (ND) ","AFB (-)","AFB (+)","MTB Not Detected\n(N)","MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)","MTB Detected (including trace), \nRIF Resistance Detected\n(RR)","MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)","Inavlid\nNo Result Error\n(I)","LAM Positive","LAM Negative","Invalid"]
["Time Period Two          ***          Time Period Two          ***          Time Period Two          ***          Time Period Two          ***         Time Period Two     ***     Time Period Two          ***          Time Period Two          ***          Time Period Two          ***          Time Period Two          ***         Time Period Two",1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,"Total",{"$f":"SUM(AggPresumptiveP2[Total Presumptive TB])","v":0},{"$f":"SUM(AggPresumptiveP2[Age 0-14])","v":0},{"$f":"SUM(AggPresumptiveP2[Age 15+ ])","v":0},{"$f":"SUM(AggPresumptiveP2[Males])","v":0},{"$f":"SUM(AggPresumptiveP2[Females])","v":0},{"$f":"SUM(AggPresumptiveP2[Number Specimens Collected])","v":0},{"$f":"SUM(AggPresumptiveP2[HIV Positive])","v":0},{"$f":"SUM(AggPresumptiveP2[HIV Negative])","v":0},{"$f":"SUM(AggPresumptiveP2[Not Tested])","v":0},{"$f":"SUM(AggPresumptiveP2[Not Done (ND) ])","v":0},{"$f":"SUM(AggPresumptiveP2[AFB (-)])","v":0},{"$f":"SUM(AggPresumptiveP2[AFB (+)])","v":0},{"$f":"SUM(AggPresumptiveP2[MTB Not Detected\n(N)])","v":0},{"$f":"SUM(AggPresumptiveP2[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)])","v":0},{"$f":"SUM(AggPresumptiveP2[MTB Detected (including trace), \nRIF Resistance Detected\n(RR)])","v":0},{"$f":"SUM(AggPresumptiveP2[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)])","v":0},{"$f":"SUM(AggPresumptiveP2[Inavlid\nNo Result Error\n(I)])","v":0},{"$f":"SUM(AggPresumptiveP2[LAM Positive])","v":0},{"$f":"SUM(AggPresumptiveP2[LAM Negative])","v":0},{"$f":"SUM(AggPresumptiveP2[Invalid])","v":0}]
[null,"Total",{"$f":"AggPresumptiveP2[[#Totals],[Total Presumptive TB]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[Age 0-14]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[Age 15+ ]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[Males]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[Females]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[Number Specimens Collected]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[HIV Positive]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[HIV Negative]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[Not Tested]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[Not Done (ND) ]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[AFB (-)]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[AFB (+)]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[MTB Not Detected\n(N)]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[MTB Detected (including trace), \nRIF Resistance Detected\n(RR)]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[Inavlid\nNo Result Error\n(I)]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[LAM Positive]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[LAM Negative]]","v":0},{"$f":"AggPresumptiveP2[[#Totals],[Invalid]]","v":0}]
[]
[]
[null,null,null,"(6)",null,"(7)",null,null,"(9)",null,null,"(12)"]
[null,null,null,"Age",null,"Sex",null,"Specimen","Known HIV Status",null,"Unknown HIV Status","Microscopy",null,null,"NAAT",null,null,null,null,"TB LAM"]
["top","Register Page #","Total Presumptive TB","Age 0-14","Age 15+ ","Males","Females","Number Specimens Collected","HIV Positive","HIV Negative","Not Tested","Not Done (ND)","AFB (-)","AFB (+)","MTB Not Detected\n(N)","MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)","MTB Detected (including trace), \nRIF Resistance Detected\n(RR)","MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)","Inavlid\nNo Result Error\n(I)","LAM Positive","LAM Negative","Invalid"]
["Time Period Three          ***          Time Period Three         ***         Time Period Three          ***          Time Period Three          ***         Time Period Three     ***     Time Period Three          ***          Time Period Three         ***         Time Period Three          ***          Time Period Three          ***         Time Period Three",1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,"Total",{"$f":"SUM(AggPresumptiveP3[Total Presumptive TB])","v":0},{"$f":"SUM(AggPresumptiveP3[Age 0-14])","v":0},{"$f":"SUM(AggPresumptiveP3[Age 15+ ])","v":0},{"$f":"SUM(AggPresumptiveP3[Males])","v":0},{"$f":"SUM(AggPresumptiveP3[Females])","v":0},{"$f":"SUM(AggPresumptiveP3[Number Specimens Collected])","v":0},{"$f":"SUM(AggPresumptiveP3[HIV Positive])","v":0},{"$f":"SUM(AggPresumptiveP3[HIV Negative])","v":0},{"$f":"SUM(AggPresumptiveP3[Not Tested])","v":0},{"$f":"SUM(AggPresumptiveP3[Not Done (ND)])","v":0},{"$f":"SUM(AggPresumptiveP3[AFB (-)])","v":0},{"$f":"SUM(AggPresumptiveP3[AFB (+)])","v":0},{"$f":"SUM(AggPresumptiveP3[MTB Not Detected\n(N)])","v":0},{"$f":"SUM(AggPresumptiveP3[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)])","v":0},{"$f":"SUM(AggPresumptiveP3[MTB Detected (including trace), \nRIF Resistance Detected\n(RR)])","v":0},{"$f":"SUM(AggPresumptiveP3[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)])","v":0},{"$f":"SUM(AggPresumptiveP3[Inavlid\nNo Result Error\n(I)])","v":0},{"$f":"SUM(AggPresumptiveP3[LAM Positive])","v":0},{"$f":"SUM(AggPresumptiveP3[LAM Negative])","v":0},{"$f":"SUM(AggPresumptiveP3[Invalid])","v":0}]
[null,"Total",{"$f":"AggPresumptiveP3[[#Totals],[Total Presumptive TB]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[Age 0-14]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[Age 15+ ]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[Males]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[Females]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[Number Specimens Collected]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[HIV Positive]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[HIV Negative]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[Not Tested]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[Not Done (ND)]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[AFB (-)]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[AFB (+)]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[MTB Not Detected\n(N)]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[MTB Detected (including trace), \nRIF Resistance Detected\n(RR)]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[Inavlid\nNo Result Error\n(I)]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[LAM Positive]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[LAM Negative]]","v":0},{"$f":"AggPresumptiveP3[[#Totals],[Invalid]]","v":0}]

{"sheet":"5b. PRESUMPTIVE REGISTER -  PL","index":6,"n_rows":37,"n_cols":20,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,1,36,6],[11,14,11,18],[11,6,11,13],[0,1,0,6],[35,1,35,6],[10,1,10,18],[4,1,6,5],[2,1,2,5],[3,1,3,5]]}
[null,"PRESUMPTIVE TB REGISTER: PATIENT-LEVEL DATA"]
[]
[null,"Instructions: \n"]
[null,"1. Gather Presumptive TB Registers for data abstraction period. "]
[null,"Sampling: \nSample size will be determined by calculating 5% of total presumptives found in the Presumptive TB Register, with a minimum of 6 and a maximum of 20. Select half HIV+ individuals and half HIV- individuals randomly, irrespective of data quality or completion. "]
[]
[]
[]
[null,"Total Patients Captured:",null,{"$f":"PLPresumptive[[#Totals],[Patient Count Helper Column]]","v":0}]
[]
[null,"TB CLINIC PRESUMPTIVE TB REGISTER: PATIENT-LEVEL"]
[null,null,null,null,null,null,"Specimen Information",null,null,null,null,null,null,null,"HIV"]
[null,"PATIENT","Specimen ID Number","Sex","Age \n(<15, 15+)","Who Referred the Patient? ","Specimen Collection Documented","Date of Specimen Collection*","Date Specimen was Sent to Lab*","Date TB Result Released*","AFB Result","LAM Result","Xpert MTB Result","Xpert RIF Result","Known HIV Status","Unknown HIV Status","Error (with Code)","Invalid or Incomplete Test","Date HIV Result Released*","Patient Count Helper Column"]
[null,"P1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(PLPresumptive[[#This Row],[Specimen ID Number]:[Date HIV Result Released*]])","v":0}]
[null,"P2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(PLPresumptive[[#This Row],[Specimen ID Number]:[Date HIV Result Released*]])","v":0}]
[null,"P3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(PLPresumptive[[#This Row],[Specimen ID Number]:[Date HIV Result Released*]])","v":0}]
[null,"P4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(PLPresumptive[[#This Row],[Specimen ID Number]:[Date HIV Result Released*]])","v":0}]
[null,"P5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(PLPresumptive[[#This Row],[Specimen ID Number]:[Date HIV Result Released*]])","v":0}]
[null,"P6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(PLPresumptive[[#This Row],[Specimen ID Number]:[Date HIV Result Released*]])","v":0}]
[null,"P7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(PLPresumptive[[#This Row],[Specimen ID Number]:[Date HIV Result Released*]])","v":0}]
[null,"P8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(PLPresumptive[[#This Row],[Specimen ID Number]:[Date HIV Result Released*]])","v":0}]
[null,"P9",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(PLPresumptive[[#This Row],[Specimen ID Number]:[Date HIV Result Released*]])","v":0}]
[null,"P10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(PLPresumptive[[#This Row],[Specimen ID Number]:[Date HIV Result Released*]])","v":0}]
[null,"P11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(PLPresumptive[[#This Row],[Specimen ID Number]:[Date HIV Result Released*]])","v":0}]
[null,"P12",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(PLPresumptive[[#This Row],[Specimen ID Number]:[Date HIV Result Released*]])","v":0}]
[null,"P13",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(PLPresumptive[[#This Row],[Specimen ID Number]:[Date HIV Result Released*]])","v":0}]
[null,"P14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(PLPresumptive[[#This Row],[Specimen ID Number]:[Date HIV Result Released*]])","v":0}]
[null,"P15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(PLPresumptive[[#This Row],[Specimen ID Number]:[Date HIV Result Released*]])","v":0}]
[null,"P16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(PLPresumptive[[#This Row],[Specimen ID Number]:[Date HIV Result Released*]])","v":0}]
[null,"P17",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(PLPresumptive[[#This Row],[Specimen ID Number]:[Date HIV Result Released*]])","v":0}]
[null,"P18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(PLPresumptive[[#This Row],[Specimen ID Number]:[Date HIV Result Released*]])","v":0}]
[null,"P19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(PLPresumptive[[#This Row],[Specimen ID Number]:[Date HIV Result Released*]])","v":0}]
[null,"P20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(PLPresumptive[[#This Row],[Specimen ID Number]:[Date HIV Result Released*]])","v":0}]
[null,"Complete",{"$f":"COUNTA(PLPresumptive[Specimen ID Number])","v":0},{"$f":"COUNTA(PLPresumptive[Sex])","v":0},{"$f":"COUNTA(PLPresumptive[Age \n(<15, 15+)])","v":0},{"$f":"COUNTA(PLPresumptive[Who Referred the Patient? ])","v":0},{"$f":"COUNTA(PLPresumptive[Specimen Collection Documented])","v":0},{"$f":"COUNTA(PLPresumptive[Date of Specimen Collection*])","v":0},{"$f":"COUNTA(PLPresumptive[Date Specimen was Sent to Lab*])","v":0},{"$f":"COUNTA(PLPresumptive[Date TB Result Released*])","v":0},{"$f":"COUNTA(PLPresumptive[AFB Result])","v":0},{"$f":"COUNTA(PLPresumptive[LAM Result])","v":0},{"$f":"COUNTA(PLPresumptive[Xpert MTB Result])","v":0},{"$f":"COUNTA(PLPresumptive[Xpert RIF Result])","v":0},{"$f":"COUNTA(PLPresumptive[Known HIV Status])","v":0},{"$f":"COUNTA(PLPresumptive[Unknown HIV Status])","v":0},{"$f":"COUNTA(PLPresumptive[Error (with Code)])","v":0},{"$f":"COUNTA(PLPresumptive[Invalid or Incomplete Test])","v":0},{"$f":"COUNTA(PLPresumptive[Date HIV Result Released*])","v":0},{"$f":"COUNTIF(PLPresumptive[Patient Count Helper Column], \">0\")","v":0}]
[null,"Complete",{"$f":"PLPresumptive[[#Totals],[Specimen ID Number]]","v":0},{"$f":"PLPresumptive[[#Totals],[Sex]]","v":0},{"$f":"PLPresumptive[[#Totals],[Age \n(<15, 15+)]]","v":0},{"$f":"PLPresumptive[[#Totals],[Who Referred the Patient? ]]","v":0},{"$f":"PLPresumptive[[#Totals],[Specimen Collection Documented]]","v":0},{"$f":"PLPresumptive[[#Totals],[Date of Specimen Collection*]]","v":0},{"$f":"PLPresumptive[[#Totals],[Date Specimen was Sent to Lab*]]","v":0},{"$f":"PLPresumptive[[#Totals],[Date TB Result Released*]]","v":0},{"$f":"PLPresumptive[[#Totals],[AFB Result]]","v":0},{"$f":"PLPresumptive[[#Totals],[LAM Result]]","v":0},{"$f":"PLPresumptive[[#Totals],[Xpert MTB Result]]","v":0},{"$f":"PLPresumptive[[#Totals],[Xpert RIF Result]]","v":0},{"$f":"PLPresumptive[[#Totals],[Known HIV Status]]","v":0},{"$f":"PLPresumptive[[#Totals],[Unknown HIV Status]]","v":0},{"$f":"PLPresumptive[[#Totals],[Error (with Code)]]","v":0},{"$f":"PLPresumptive[[#Totals],[Invalid or Incomplete Test]]","v":0},{"$f":"PLPresumptive[[#Totals],[Date HIV Result Released*]]","v":0}]
[null,"*Date format: dd-mmm-yy (ex. 30-Mar-19)"]
[null,"Notes:  Dates for HIV Test Results was not documented on the Presumtive Register"]

{"sheet":"6a. LAB REGISTER - AGG","index":7,"n_rows":103,"n_cols":20,"rows_kept":103,"cut":false,"hidden":false,"merged":[[73,17,73,19],[74,14,74,16],[74,17,74,18],[0,0,0,19],[2,1,2,19],[3,1,3,19],[4,1,4,19],[5,1,5,19],[6,1,6,19],[9,17,9,19],[10,17,10,18],[9,7,9,16],[10,14,10,16],[41,7,41,16],[41,17,41,19],[42,14,42,16],[7,1,7,19],[42,5,42,6],[42,7,42,8],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,13],[42,9,42,13],[42,17,42,18],[41,3,41,4],[41,5,41,6],[9,3,9,4],[9,5,9,6],[74,3,74,4],[10,0,36,0],[42,0,68,0],[74,0,100,0],[42,3,42,4],[73,3,73,4],[74,5,74,6],[74,7,74,8],[74,9,74,13],[73,5,73,6],[73,7,73,16]]}
["AGGREGATE DATA COLLECTION: LAB REGISTER"]
[]
[null,"Instructions: "]
[null,"   1. Gather TB Lab Registers for designated data abstraction period. "]
[null,"   2. Count the page totals for each field and record them here. Each row on this page will represent sums from one page of a register; sections are provided for discrete time periods."]
[null,"Note: "]
[null,"  - Only collect data on entries where the purpose for testing is diagnosis; follow-up tests should not be recorded. "]
[null,"  - Only collect data on entries where the specimen originated from the TB/HIV clinics visited for this assessment. Samples referred from elsewhere should not be recorded. "]
[]
[null,null,null,"(6)",null,"(7)",null,"(13)",null,null,null,null,null,null,null,null,null,"(14)"]
["Time Period One          ***          Time Period One          ***          Time Period One          ***          Time Period One          ***          Time Period One     ***     Time Period One          ***          Time Period One          ***          Time Period One          ***          Time Period One          ***          Time Period One",null,null,"Sex",null,"Age",null,"Smear",null,"Gene Xpert",null,null,null,null,"TB LAM",null,null,"Known HIV Status",null,"Unknown HIV Status"]
[null,"Register Page #","Total Specimens","Female","Male","Age 0-14","Age 15+","AFB (-)","AFB (+)","MTB Not Detected\n(N)","MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)","MTB Detected (including trace), \nRIF Resistance Detected\n(RR)","MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)","Inavlid\nNo Result Error\n(I)","LAM Positive","LAM Negative","LAM Invalid","Positive","Negative","Not Tested"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
["Total",null,{"$f":"SUM(AggLabP1[Total Specimens])","v":0},{"$f":"SUM(AggLabP1[Female])","v":0},{"$f":"SUM(AggLabP1[Male])","v":0},{"$f":"SUM(AggLabP1[Age 0-14])","v":0},{"$f":"SUM(AggLabP1[Age 15+])","v":0},{"$f":"SUM(AggLabP1[AFB (-)])","v":0},{"$f":"SUM(AggLabP1[AFB (+)])","v":0},{"$f":"SUM(AggLabP1[MTB Not Detected\n(N)])","v":0},{"$f":"SUM(AggLabP1[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)])","v":0},{"$f":"SUM(AggLabP1[MTB Detected (including trace), \nRIF Resistance Detected\n(RR)])","v":0},{"$f":"SUM(AggLabP1[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)])","v":0},{"$f":"SUM(AggLabP1[Inavlid\nNo Result Error\n(I)])","v":0},{"$f":"SUM(AggLabP1[LAM Positive])","v":0},{"$f":"SUM(AggLabP1[LAM Negative])","v":0},{"$f":"SUM(AggLabP1[LAM Invalid])","v":0},{"$f":"SUM(AggLabP1[Positive])","v":0},{"$f":"SUM(AggLabP1[Negative])","v":0},{"$f":"SUM(AggLabP1[Not Tested])","v":0}]
[null,"Total",{"$f":"AggLabP1[[#Totals],[Total Specimens]]","v":0},{"$f":"AggLabP1[[#Totals],[Female]]","v":0},{"$f":"AggLabP1[[#Totals],[Male]]","v":0},{"$f":"AggLabP1[[#Totals],[Age 0-14]]","v":0},{"$f":"AggLabP1[[#Totals],[Age 15+]]","v":0},{"$f":"AggLabP1[[#Totals],[AFB (-)]]","v":0},{"$f":"AggLabP1[[#Totals],[AFB (+)]]","v":0},{"$f":"AggLabP1[[#Totals],[MTB Not Detected\n(N)]]","v":0},{"$f":"AggLabP1[[#Totals],[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)]]","v":0},{"$f":"AggLabP1[[#Totals],[MTB Detected (including trace), \nRIF Resistance Detected\n(RR)]]","v":0},{"$f":"AggLabP1[[#Totals],[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)]]","v":0},{"$f":"AggLabP1[[#Totals],[Inavlid\nNo Result Error\n(I)]]","v":0},{"$f":"AggLabP1[[#Totals],[LAM Positive]]","v":0},{"$f":"AggLabP1[[#Totals],[LAM Negative]]","v":0},{"$f":"AggLabP1[[#Totals],[LAM Invalid]]","v":0},{"$f":"AggLabP1[[#Totals],[Positive]]","v":0},{"$f":"AggLabP1[[#Totals],[Negative]]","v":0},{"$f":"AggLabP1[[#Totals],[Not Tested]]","v":0}]
[]
[]
["top",null,null,"(6)",null,"(7)",null,"(13)",null,null,null,null,null,null,null,null,null,"(14)"]
["Time Period Two          ***          Time Period Two          ***          Time Period Two          ***          Time Period Two          ***         Time Period Two     ***     Time Period Two          ***          Time Period Two          ***          Time Period Two          ***          Time Period Two          ***         Time Period Two",null,null,"Sex",null,"Age",null,"Smear",null,"Gene Xpert",null,null,null,null,"TB LAM",null,null,"Known HIV Status",null,"Unknown HIV Status"]
[null,"Register Page #","Total Specimens","Female","Male","Age 0-14","Age 15+","AFB (-)","AFB (+)","MTB Not Detected\n(N)","MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)","MTB Detected (including trace), \nRIF Resistance Detected\n(RR)","MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)","Inavlid\nNo Result Error\n(I)","LAM Positive","LAM Negative","LAM Invalid","Positive","Negative","Not Tested"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
["Total",null,{"$f":"SUM(AggLabP2[Total Specimens])","v":0},{"$f":"SUM(AggLabP2[Female])","v":0},{"$f":"SUM(AggLabP2[Male])","v":0},{"$f":"SUM(AggLabP2[Age 0-14])","v":0},{"$f":"SUM(AggLabP2[Age 15+])","v":0},{"$f":"SUM(AggLabP2[AFB (-)])","v":0},{"$f":"SUM(AggLabP2[AFB (+)])","v":0},{"$f":"SUM(AggLabP2[MTB Not Detected\n(N)])","v":0},{"$f":"SUM(AggLabP2[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)])","v":0},{"$f":"SUM(AggLabP2[MTB Detected (including trace), \nRIF Resistance Detected\n(RR)])","v":0},{"$f":"SUM(AggLabP2[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)])","v":0},{"$f":"SUM(AggLabP2[Inavlid\nNo Result Error\n(I)])","v":0},{"$f":"SUM(AggLabP2[LAM Positive])","v":0},{"$f":"SUM(AggLabP2[LAM Negative])","v":0},{"$f":"SUM(AggLabP2[LAM Invalid])","v":0},{"$f":"SUM(AggLabP2[Positive])","v":0},{"$f":"SUM(AggLabP2[Negative])","v":0},{"$f":"SUM(AggLabP2[Not Tested])","v":0}]
[null,"Total",{"$f":"AggLabP2[[#Totals],[Total Specimens]]","v":0},{"$f":"AggLabP2[[#Totals],[Female]]","v":0},{"$f":"AggLabP2[[#Totals],[Male]]","v":0},{"$f":"AggLabP2[[#Totals],[Age 0-14]]","v":0},{"$f":"AggLabP2[[#Totals],[Age 15+]]","v":0},{"$f":"AggLabP2[[#Totals],[AFB (-)]]","v":0},{"$f":"AggLabP2[[#Totals],[AFB (+)]]","v":0},{"$f":"AggLabP2[[#Totals],[MTB Not Detected\n(N)]]","v":0},{"$f":"AggLabP2[[#Totals],[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)]]","v":0},{"$f":"AggLabP2[[#Totals],[MTB Detected (including trace), \nRIF Resistance Detected\n(RR)]]","v":0},{"$f":"AggLabP2[[#Totals],[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)]]","v":0},{"$f":"AggLabP2[[#Totals],[Inavlid\nNo Result Error\n(I)]]","v":0},{"$f":"AggLabP2[[#Totals],[LAM Positive]]","v":0},{"$f":"AggLabP2[[#Totals],[LAM Negative]]","v":0},{"$f":"AggLabP2[[#Totals],[LAM Invalid]]","v":0},{"$f":"AggLabP2[[#Totals],[Positive]]","v":0},{"$f":"AggLabP2[[#Totals],[Negative]]","v":0},{"$f":"AggLabP2[[#Totals],[Not Tested]]","v":0}]
[]
[]
["top",null,null,"(6)",null,"(7)",null,"(13)",null,null,null,null,null,null,null,null,null,"(14)"]
["Time Period Three          ***          Time Period Three         ***         Time Period Three          ***          Time Period Three          ***         Time Period Three     ***     Time Period Three          ***          Time Period Three         ***         Time Period Three          ***          Time Period Three          ***         Time Period Three",null,null,"Sex",null,"Age",null,"Smear",null,"Gene Xpert",null,null,null,null,"TB LAM",null,null,"Known HIV Status",null,"Unknown HIV Status"]
[null,"Register Page #","Total Specimens","Female","Male","Age 0-14","Age 15+","AFB (-)","AFB (+)","MTB Not Detected\n(N)","MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)","MTB Detected (including trace), \nRIF Resistance Detected\n(RR)","MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)","Inavlid\nNo Result Error\n(I)","LAM Positive","LAM Negative","LAM Invalid","Positive","Negative","Not Tested"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
["Total",null,{"$f":"SUM(AggLabP3[Total Specimens])","v":0},{"$f":"SUM(AggLabP3[Female])","v":0},{"$f":"SUM(AggLabP3[Male])","v":0},{"$f":"SUM(AggLabP3[Age 0-14])","v":0},{"$f":"SUM(AggLabP3[Age 15+])","v":0},{"$f":"SUM(AggLabP3[AFB (-)])","v":0},{"$f":"SUM(AggLabP3[AFB (+)])","v":0},{"$f":"SUM(AggLabP3[MTB Not Detected\n(N)])","v":0},{"$f":"SUM(AggLabP3[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)])","v":0},{"$f":"SUM(AggLabP3[MTB Detected (including trace), \nRIF Resistance Detected\n(RR)])","v":0},{"$f":"SUM(AggLabP3[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)])","v":0},{"$f":"SUM(AggLabP3[Inavlid\nNo Result Error\n(I)])","v":0},{"$f":"SUM(AggLabP3[LAM Positive])","v":0},{"$f":"SUM(AggLabP3[LAM Negative])","v":0},{"$f":"SUM(AggLabP3[LAM Invalid])","v":0},{"$f":"SUM(AggLabP3[Positive])","v":0},{"$f":"SUM(AggLabP3[Negative])","v":0},{"$f":"SUM(AggLabP3[Not Tested])","v":0}]
[null,"Total",{"$f":"AggLabP3[[#Totals],[Total Specimens]]","v":0},{"$f":"AggLabP3[[#Totals],[Female]]","v":0},{"$f":"AggLabP3[[#Totals],[Male]]","v":0},{"$f":"AggLabP3[[#Totals],[Age 0-14]]","v":0},{"$f":"AggLabP3[[#Totals],[Age 15+]]","v":0},{"$f":"AggLabP3[[#Totals],[AFB (-)]]","v":0},{"$f":"AggLabP3[[#Totals],[AFB (+)]]","v":0},{"$f":"AggLabP3[[#Totals],[MTB Not Detected\n(N)]]","v":0},{"$f":"AggLabP3[[#Totals],[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)]]","v":0},{"$f":"AggLabP3[[#Totals],[MTB Detected (including trace), \nRIF Resistance Detected\n(RR)]]","v":0},{"$f":"AggLabP3[[#Totals],[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)]]","v":0},{"$f":"AggLabP3[[#Totals],[Inavlid\nNo Result Error\n(I)]]","v":0},{"$f":"AggLabP3[[#Totals],[LAM Positive]]","v":0},{"$f":"AggLabP3[[#Totals],[LAM Negative]]","v":0},{"$f":"AggLabP3[[#Totals],[LAM Invalid]]","v":0},{"$f":"AggLabP3[[#Totals],[Positive]]","v":0},{"$f":"AggLabP3[[#Totals],[Negative]]","v":0},{"$f":"AggLabP3[[#Totals],[Not Tested]]","v":0}]

{"sheet":"6b. LAB REGISTER - PL","index":8,"n_rows":32,"n_cols":18,"rows_kept":32,"cut":false,"hidden":false,"merged":[[7,1,7,17],[31,1,31,6],[32,1,32,6],[8,5,8,6],[8,7,8,10],[8,12,8,15],[0,1,0,22],[2,1,2,6],[3,1,3,6],[4,1,4,6],[5,1,5,6]]}
[null,"LAB REGISTER: PATIENT-LEVEL DATA"]
[]
[null,"Instructions: \n"]
[null,"1. Gather lab registers for designated data abstraction period. "]
[null,"2. Only collect data on entries where the purpose for testing is diagnosis; follow-up tests should not be recorded. "]
[null,"3. Only collect data on entries where the specimen originated from the TB/HIV clinics of interest. Samples referred form elsewhere should not be recorded. "]
[]
[null,"LAB REGISTER: PATIENT-LEVEL (ONLY DIAGNOSTIC TESTING)"]
[null,null,null,null,null,"HIV",null,"Specimen information",null,null,null,null,"Xpert Activities"]
[null,"Patient","Available in Lab Register?","Sex","Age\n(<15, 15+)","Known HIV Status","Unknown HIV Status","Specimen ID","Date specimen received by lab*","Type of Specimen","Type of Test","AFB Result","Specify Reason for Xpert Test","Xpert MTB Result","Xpert RIF Result","Error/Invalid/Incomplete Test","LAM Result","Date Lab Results Released*"]
[null,"P1"]
[null,"P2"]
[null,"P3"]
[null,"P4"]
[null,"P5"]
[null,"P6"]
[null,"P7"]
[null,"P8"]
[null,"P9"]
[null,"P10"]
[null,"P11"]
[null,"P12"]
[null,"P13"]
[null,"P14"]
[null,"P15"]
[null,"P16"]
[null,"P17"]
[null,"P18"]
[null,"P19"]
[null,"P20"]
[null,"Complete ",{"$f":"COUNTA(PLLab[Available in Lab Register?])","v":0},{"$f":"COUNTA(PLLab[Sex])","v":0},{"$f":"COUNTA(PLLab[Age\n(<15, 15+)])","v":0},{"$f":"COUNTA(PLLab[Known HIV Status])","v":0},{"$f":"COUNTA(PLLab[Unknown HIV Status])","v":0},{"$f":"COUNTA(PLLab[Specimen ID])","v":0},{"$f":"COUNTA(PLLab[Date specimen received by lab*])","v":0},{"$f":"COUNTA(PLLab[Type of Specimen])","v":0},{"$f":"COUNTA(PLLab[Type of Test])","v":0},{"$f":"COUNTA(PLLab[AFB Result])","v":0},{"$f":"COUNTA(PLLab[Specify Reason for Xpert Test])","v":0},{"$f":"COUNTA(PLLab[Xpert MTB Result])","v":0},{"$f":"COUNTA(PLLab[Xpert RIF Result])","v":0},{"$f":"COUNTA(PLLab[Error/Invalid/Incomplete Test])","v":0},{"$f":"COUNTA(PLLab[LAM Result])","v":0},{"$f":"COUNTA(PLLab[Date Lab Results Released*])","v":0}]
[null,"*Date format: dd-mmm-yy (ex. 30-Mar-19)"]

{"sheet":"7a. TB TX REGISTER - AGG","index":9,"n_rows":103,"n_cols":35,"rows_kept":103,"cut":false,"hidden":false,"merged":[[6,3,6,4],[6,5,6,6],[8,16,8,20],[7,5,8,6],[7,3,8,4],[7,12,8,12],[7,26,8,26],[73,0,101,0],[40,0,68,0],[8,13,8,15],[7,13,7,20],[8,21,8,24],[7,21,7,25],[40,3,41,4],[73,3,74,4],[73,5,74,6],[40,5,41,6],[40,7,41,11],[40,12,41,12],[72,13,72,20],[72,21,72,25],[40,21,40,25],[40,33,41,33],[40,34,41,34],[7,27,8,32],[6,27,6,32],[39,7,39,11],[39,13,39,20],[39,21,39,25],[39,27,39,32],[7,7,8,11],[6,7,6,11],[6,13,6,20],[40,13,40,20],[41,13,41,15],[6,21,6,25],[7,33,8,33],[7,34,8,34],[40,26,41,26],[40,27,41,32],[39,3,39,4],[39,5,39,6],[72,3,72,4],[72,5,72,6],[72,7,72,11],[6,0,35,0],[40,1,41,2],[73,33,74,33],[73,34,74,34],[74,13,74,15],[74,16,74,20],[74,21,74,24],[72,27,72,32],[73,7,74,11],[73,12,74,12],[73,13,73,20],[73,21,73,25],[73,26,74,26],[73,27,74,32],[41,16,41,20],[41,21,41,24]]}
["TB TREATMENT REGISTER JOB AID"]
[]
[null,"Instructions: "]
[null,"   1. Gather TB Treatment registers for designated data abstraction period. "]
[null,"   2. Count the page totals for each field and record them here. Each row on this page will represent sums from one page of a register; sections are provided for discrete time periods."]
[]
["Time Period One          ***          Time Period One          ***          Time Period One          ***          Time Period One          ***          Time Period One     ***     Time Period One          ***          Time Period One          ***          Time Period One          ***          Time Period One          ***          Time Period One",null,null,"5",null,6,null,11,null,null,null,null,14,16,null,null,null,null,null,null,null,"18",null,null,null,null,"21","22",null,null,null,null,null,23,24]
[null,null,null,"Sex",null,"Age",null,"Type of TB Patient",null,null,null,null,null,"Pre - Rx",null,null,null,null,null,null,null,"TB/HIV Activities",null,null,null,null,null,"Treatment Outcome"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sputum Smear Results",null,null,"Gene Expert test",null,null,null,null,"HIV Status",null,null,null,"ART Care"]
[null,"Register Page #","Total Patients ","Female","Male","Age 0-14","Age 15+","New \n(N)","Relapse (R)","Treatment After Failure (TF)","Treatment After Loss to Follow-up (TL)","Treatment History Unknown\n (THU)","Transfer In","Not Done (ND)","Smear Postive (+/ ++/ +++)","Smear Negative (-)","MTB Not Detected\n(N)","MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)","MTB Detected (including trace), \nRIF Resistance Detected\n(RR)","MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)","Inavlid\nNo Result Error\n(I)","Negative (Neg)","Known HIV Positive (KPos)","Newly Tested HIV Positive (NPos)","Unknown (Unk)","Enrolled in ART","Transferred Out","Cured\n(C)"," Completed\nTreatment\n(CTD)","Treatment Failed\n(F)","Died\n(D)","Lost to Follow-up\n(L)","Not Evaluated\n(NT)","Diagnosed with DR TB ","Transferred to 2nd Line Treatment"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,"Total",{"$f":"SUM(AggTreatmentP1[[Total Patients ]])","v":0},{"$f":"SUM(AggTreatmentP1[Female])","v":0},{"$f":"SUM(AggTreatmentP1[Male])","v":0},{"$f":"SUM(AggTreatmentP1[Age 0-14])","v":0},{"$f":"SUM(AggTreatmentP1[Age 15+])","v":0},{"$f":"SUM(AggTreatmentP1[New \n(N)])","v":0},{"$f":"SUM(AggTreatmentP1[Relapse (R)])","v":0},{"$f":"SUM(AggTreatmentP1[Treatment After Failure (TF)])","v":0},{"$f":"SUM(AggTreatmentP1[Treatment After Loss to Follow-up (TL)])","v":0},{"$f":"SUM(AggTreatmentP1[Treatment History Unknown\n (THU)])","v":0},{"$f":"SUM(AggTreatmentP1[Transfer In])","v":0},{"$f":"SUM(AggTreatmentP1[Not Done (ND)])","v":0},{"$f":"SUM(AggTreatmentP1[Smear Postive (+/ ++/ +++)])","v":0},{"$f":"SUM(AggTreatmentP1[Smear Negative (-)])","v":0},{"$f":"SUM(AggTreatmentP1[MTB Not Detected\n(N)])","v":0},{"$f":"SUM(AggTreatmentP1[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)])","v":0},{"$f":"SUM(AggTreatmentP1[MTB Detected (including trace), \nRIF Resistance Detected\n(RR)])","v":0},{"$f":"SUM(AggTreatmentP1[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)])","v":0},{"$f":"SUM(AggTreatmentP1[Inavlid\nNo Result Error\n(I)])","v":0},{"$f":"SUM(AggTreatmentP1[Negative (Neg)])","v":0},{"$f":"SUM(AggTreatmentP1[Known HIV Positive (KPos)])","v":0},{"$f":"SUM(AggTreatmentP1[Newly Tested HIV Positive (NPos)])","v":0},{"$f":"SUM(AggTreatmentP1[Unknown (Unk)])","v":0},{"$f":"SUM(AggTreatmentP1[Enrolled in ART])","v":0},{"$f":"SUM(AggTreatmentP1[Transferred Out])","v":0},{"$f":"SUM(AggTreatmentP1[Cured\n(C)])","v":0},{"$f":"SUM(AggTreatmentP1[ Completed\nTreatment\n(CTD)])","v":0},{"$f":"SUM(AggTreatmentP1[Treatment Failed\n(F)])","v":0},{"$f":"SUM(AggTreatmentP1[Died\n(D)])","v":0},{"$f":"SUM(AggTreatmentP1[Lost to Follow-up\n(L)])","v":0},{"$f":"SUM(AggTreatmentP1[Not Evaluated\n(NT)])","v":0},{"$f":"SUM(AggTreatmentP1[[Diagnosed with DR TB ]])","v":0},{"$f":"SUM(AggTreatmentP1[Transferred to 2nd Line Treatment])","v":0}]
[null,"Total",{"$f":"AggTreatmentP1[[#Totals],[Total Patients ]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[Female]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[Male]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[Age 0-14]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[Age 15+]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[New \n(N)]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[Relapse (R)]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[Treatment After Failure (TF)]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[Treatment After Loss to Follow-up (TL)]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[Treatment History Unknown\n (THU)]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[Transfer In]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[Not Done (ND)]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[Smear Postive (+/ ++/ +++)]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[Smear Negative (-)]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[MTB Not Detected\n(N)]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[MTB Detected (including trace), \nRIF Resistance Detected\n(RR)]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[Inavlid\nNo Result Error\n(I)]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[Negative (Neg)]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[Known HIV Positive (KPos)]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[Newly Tested HIV Positive (NPos)]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[Unknown (Unk)]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[Enrolled in ART]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[Transferred Out]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[Cured\n(C)]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[ Completed\nTreatment\n(CTD)]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[Treatment Failed\n(F)]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[Died\n(D)]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[Lost to Follow-up\n(L)]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[Not Evaluated\n(NT)]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[Diagnosed with DR TB ]]","v":0},{"$f":"AggTreatmentP1[[#Totals],[Transferred to 2nd Line Treatment]]","v":0}]
[]
[]
["top",null,null,"5",null,6,null,11,null,null,null,null,14,16,null,null,null,null,null,null,null,"18",null,null,null,null,"21","22",null,null,null,null,null,23,24]
["Time Period Two          ***          Time Period Two          ***          Time Period Two          ***          Time Period Two          ***         Time Period Two     ***     Time Period Two          ***          Time Period Two          ***          Time Period Two          ***          Time Period Two          ***         Time Period Two",null,null,"Sex",null,"Age",null,"Type of TB Patient",null,null,null,null,null,"Pre - Rx",null,null,null,null,null,null,null,"TB/HIV Activities",null,null,null,null,null,"Treatment Outcome"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sputum Smear Results",null,null,"Gene Expert test",null,null,null,null,"HIV Status",null,null,null,"ART Care"]
[null,"Register Page #","Total Patients ","Female","Male","Age 0-14","Age 15+","New \n(N)","Relapse (R)","Treatment After Failure (TF)","Treatment After Loss to Follow-up (TL)","Treatment History Unknown\n (THU)","Transfer In","Not Done (ND)","Smear Postive (+/ ++/ +++)","Smear Negative (-)","MTB Not Detected\n(N)","MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)","MTB Detected (including trace), \nRIF Resistance Detected\n(RR)","MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)","Inavlid\nNo Result Error\n(I)","Negative (Neg)","Known HIV Positive (KPos)","Newly Tested HIV Positive (NPos)","Unknown (Unk)","Enrolled in ART","Transferred Out","Cured\n(C)"," Completed\nTreatment\n(CTD)","Treatment Failed\n(F)","Died\n(D)","Lost to Follow-up\n(L)","Not Evaluated\n(NT)","Diagnosed with DR TB ","Transferred to 2nd Line Treatment"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,"Total",{"$f":"SUM(AggTreatmentP2[[Total Patients ]])","v":0},{"$f":"SUM(AggTreatmentP2[Female])","v":0},{"$f":"SUM(AggTreatmentP2[Male])","v":0},{"$f":"SUM(AggTreatmentP2[Age 0-14])","v":0},{"$f":"SUM(AggTreatmentP2[Age 15+])","v":0},{"$f":"SUM(AggTreatmentP2[New \n(N)])","v":0},{"$f":"SUM(AggTreatmentP2[Relapse (R)])","v":0},{"$f":"SUM(AggTreatmentP2[Treatment After Failure (TF)])","v":0},{"$f":"SUM(AggTreatmentP2[Treatment After Loss to Follow-up (TL)])","v":0},{"$f":"SUM(AggTreatmentP2[Treatment History Unknown\n (THU)])","v":0},{"$f":"SUM(AggTreatmentP2[Transfer In])","v":0},{"$f":"SUM(AggTreatmentP2[Not Done (ND)])","v":0},{"$f":"SUM(AggTreatmentP2[Smear Postive (+/ ++/ +++)])","v":0},{"$f":"SUM(AggTreatmentP2[Smear Negative (-)])","v":0},{"$f":"SUM(AggTreatmentP2[MTB Not Detected\n(N)])","v":0},{"$f":"SUM(AggTreatmentP2[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)])","v":0},{"$f":"SUM(AggTreatmentP2[MTB Detected (including trace), \nRIF Resistance Detected\n(RR)])","v":0},{"$f":"SUM(AggTreatmentP2[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)])","v":0},{"$f":"SUM(AggTreatmentP2[Inavlid\nNo Result Error\n(I)])","v":0},{"$f":"SUM(AggTreatmentP2[Negative (Neg)])","v":0},{"$f":"SUM(AggTreatmentP2[Known HIV Positive (KPos)])","v":0},{"$f":"SUM(AggTreatmentP2[Newly Tested HIV Positive (NPos)])","v":0},{"$f":"SUM(AggTreatmentP2[Unknown (Unk)])","v":0},{"$f":"SUM(AggTreatmentP2[Enrolled in ART])","v":0},{"$f":"SUM(AggTreatmentP2[Transferred Out])","v":0},{"$f":"SUM(AggTreatmentP2[Cured\n(C)])","v":0},{"$f":"SUM(AggTreatmentP2[ Completed\nTreatment\n(CTD)])","v":0},{"$f":"SUM(AggTreatmentP2[Treatment Failed\n(F)])","v":0},{"$f":"SUM(AggTreatmentP2[Died\n(D)])","v":0},{"$f":"SUM(AggTreatmentP2[Lost to Follow-up\n(L)])","v":0},{"$f":"SUM(AggTreatmentP2[Not Evaluated\n(NT)])","v":0},{"$f":"SUM(AggTreatmentP2[[Diagnosed with DR TB ]])","v":0},{"$f":"SUM(AggTreatmentP2[Transferred to 2nd Line Treatment])","v":0}]
[null,"Total",{"$f":"AggTreatmentP2[[#Totals],[Total Patients ]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Female]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Male]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Age 0-14]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Age 15+]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[New \n(N)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Relapse (R)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Treatment After Failure (TF)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Treatment After Loss to Follow-up (TL)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Treatment History Unknown\n (THU)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Transfer In]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Not Done (ND)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Smear Postive (+/ ++/ +++)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Smear Negative (-)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[MTB Not Detected\n(N)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[MTB Detected (including trace), \nRIF Resistance Detected\n(RR)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Inavlid\nNo Result Error\n(I)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Negative (Neg)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Known HIV Positive (KPos)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Newly Tested HIV Positive (NPos)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Unknown (Unk)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Enrolled in ART]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Transferred Out]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Cured\n(C)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[ Completed\nTreatment\n(CTD)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Treatment Failed\n(F)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Died\n(D)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Lost to Follow-up\n(L)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Not Evaluated\n(NT)]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Diagnosed with DR TB ]]","v":0},{"$f":"AggTreatmentP2[[#Totals],[Transferred to 2nd Line Treatment]]","v":0}]
[]
[]
["top",null,null,"5",null,6,null,11,null,null,null,null,14,16,null,null,null,null,null,null,null,"18",null,null,null,null,"21","22",null,null,null,null,null,23,24]
["Time Period Three          ***          Time Period Three         ***         Time Period Three          ***          Time Period Three          ***         Time Period Three     ***     Time Period Three          ***          Time Period Three         ***         Time Period Three          ***          Time Period Three          ***         Time Period Three",null,null,"Sex",null,"Age",null,"Type of TB Patient",null,null,null,null,null,"Pre - Rx",null,null,null,null,null,null,null,"TB/HIV Activities",null,null,null,null,null,"Treatment Outcome"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sputum Smear Results",null,null,"Gene Expert test",null,null,null,null,"HIV Status",null,null,null,"ART Care"]
[null,"Register Page #","Total Patients ","Female","Male","Age 0-14","Age 15+","New \n(N)","Relapse (R)","Treatment After Failure (TF)","Treatment After Loss to Follow-up (TL)","Treatment History Unknown\n (THU)","Transfer In","Not Done (ND)","Smear Postive (+/ ++/ +++)","Smear Negative (-)","MTB Not Detected\n(N)","MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)","MTB Detected (including trace), \nRIF Resistance Detected\n(RR)","MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)","Inavlid\nNo Result Error\n(I)","Negative (Neg)","Known HIV Positive (KPos)","Newly Tested HIV Positive (NPos)","Unknown (Unk)","Enrolled in ART","Transferred Out","Cured\n(C)"," Completed\nTreatment\n(CTD)","Treatment Failed\n(F)","Died\n(D)","Lost to Follow-up\n(L)","Not Evaluated\n(NT)","Diagnosed with DR TB ","Transferred to 2nd Line Treatment"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,"Total",{"$f":"SUM(AggTreatmentP3[[Total Patients ]])","v":0},{"$f":"SUM(AggTreatmentP3[Female])","v":0},{"$f":"SUM(AggTreatmentP3[Male])","v":0},{"$f":"SUM(AggTreatmentP3[Age 0-14])","v":0},{"$f":"SUM(AggTreatmentP3[Age 15+])","v":0},{"$f":"SUM(AggTreatmentP3[New \n(N)])","v":0},{"$f":"SUM(AggTreatmentP3[Relapse (R)])","v":0},{"$f":"SUM(AggTreatmentP3[Treatment After Failure (TF)])","v":0},{"$f":"SUM(AggTreatmentP3[Treatment After Loss to Follow-up (TL)])","v":0},{"$f":"SUM(AggTreatmentP3[Treatment History Unknown\n (THU)])","v":0},{"$f":"SUM(AggTreatmentP3[Transfer In])","v":0},{"$f":"SUM(AggTreatmentP3[Not Done (ND)])","v":0},{"$f":"SUM(AggTreatmentP3[Smear Postive (+/ ++/ +++)])","v":0},{"$f":"SUM(AggTreatmentP3[Smear Negative (-)])","v":0},{"$f":"SUM(AggTreatmentP3[MTB Not Detected\n(N)])","v":0},{"$f":"SUM(AggTreatmentP3[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)])","v":0},{"$f":"SUM(AggTreatmentP3[MTB Detected (including trace), \nRIF Resistance Detected\n(RR)])","v":0},{"$f":"SUM(AggTreatmentP3[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)])","v":0},{"$f":"SUM(AggTreatmentP3[Inavlid\nNo Result Error\n(I)])","v":0},{"$f":"SUM(AggTreatmentP3[Negative (Neg)])","v":0},{"$f":"SUM(AggTreatmentP3[Known HIV Positive (KPos)])","v":0},{"$f":"SUM(AggTreatmentP3[Newly Tested HIV Positive (NPos)])","v":0},{"$f":"SUM(AggTreatmentP3[Unknown (Unk)])","v":0},{"$f":"SUM(AggTreatmentP3[Enrolled in ART])","v":0},{"$f":"SUM(AggTreatmentP3[Transferred Out])","v":0},{"$f":"SUM(AggTreatmentP3[Cured\n(C)])","v":0},{"$f":"SUM(AggTreatmentP3[ Completed\nTreatment\n(CTD)])","v":0},{"$f":"SUM(AggTreatmentP3[Treatment Failed\n(F)])","v":0},{"$f":"SUM(AggTreatmentP3[Died\n(D)])","v":0},{"$f":"SUM(AggTreatmentP3[Lost to Follow-up\n(L)])","v":0},{"$f":"SUM(AggTreatmentP3[Not Evaluated\n(NT)])","v":0},{"$f":"SUM(AggTreatmentP3[[Diagnosed with DR TB ]])","v":0},{"$f":"SUM(AggTreatmentP3[Transferred to 2nd Line Treatment])","v":0}]
[null,"Total",{"$f":"AggTreatmentP3[[#Totals],[Total Patients ]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Female]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Male]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Age 0-14]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Age 15+]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[New \n(N)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Relapse (R)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Treatment After Failure (TF)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Treatment After Loss to Follow-up (TL)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Treatment History Unknown\n (THU)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Transfer In]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Not Done (ND)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Smear Postive (+/ ++/ +++)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Smear Negative (-)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[MTB Not Detected\n(N)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[MTB Detected\n(including trace), \nRIF Resistance not Detected\n(T)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[MTB Detected (including trace), \nRIF Resistance Detected\n(RR)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[MTB Detected (including trace), \nRIF Resistance Indeterminate\n(TI)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Inavlid\nNo Result Error\n(I)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Negative (Neg)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Known HIV Positive (KPos)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Newly Tested HIV Positive (NPos)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Unknown (Unk)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Enrolled in ART]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Transferred Out]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Cured\n(C)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[ Completed\nTreatment\n(CTD)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Treatment Failed\n(F)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Died\n(D)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Lost to Follow-up\n(L)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Not Evaluated\n(NT)]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Diagnosed with DR TB ]]","v":0},{"$f":"AggTreatmentP3[[#Totals],[Transferred to 2nd Line Treatment]]","v":0}]

{"sheet":"7b. TB TX REGISTER - PL","index":10,"n_rows":30,"n_cols":21,"rows_kept":30,"cut":false,"hidden":false,"merged":[[30,1,30,6],[0,1,0,6],[2,1,2,7],[3,1,3,7],[5,1,5,20],[6,17,6,20],[29,1,29,6]]}
[null,"TB TREATMENT REGISTER: PATIENT-LEVEL DATA"]
[]
[null,"Instructions: \n"]
[null,"1. Gather TB Treatment registers for designated data abstraction period and abstract for patients in selected sample."]
[]
[null,"TB TREATMENT REGISTER: PATIENT-LEVEL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HIV"]
[null,"PATIENT","Available in Register?","Date of Registration*","TB Registration Number","Sex","Age \n(<15, 15+)","Date Treatment Started*","Registration Group","Month 0 Smear Result","Month 0 Date (Smear)","Xpert MTB Result","Xpert RIF Result","Chest X-Ray Suggestive? ","TB Registration No. ","Treatment Outcome","Date of Treatment Outcome*","HIV Status at Beginning of Treatment","On ART?","ART Start Date*","HIV Status at End of Treatment"]
[null,"P1"]
[null,"P2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Negative",null,null,"Unknown"]
[null,"P3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Negative",null,null,"Unknown"]
[null,"P4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Negative",null,null,"Unknown"]
[null,"P5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unknown",null,null,"Unknown"]
[null,"P6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Positive","Yes","2007-06-15","Positive"]
[null,"P7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Negative",null,null,"Unknown"]
[null,"P8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Negative",null,null,"Unknown"]
[null,"P9",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Negative",null,null,"Unknown"]
[null,"P10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Negative",null,null,"Unknown"]
[null,"P11"]
[null,"P12"]
[null,"P13"]
[null,"P14"]
[null,"P15"]
[null,"P16"]
[null,"P17"]
[null,"P18"]
[null,"P19"]
[null,"P20"]
[null,"Complete",{"$f":"COUNTA(PLTreatment[Available in Register?])","v":0},{"$f":"COUNTA(PLTreatment[Date of Registration*])","v":0},{"$f":"COUNTA(PLTreatment[TB Registration Number])","v":0},{"$f":"COUNTA(PLTreatment[Sex])","v":0},{"$f":"COUNTA(PLTreatment[Age \n(<15, 15+)])","v":0},{"$f":"COUNTA(PLTreatment[Date Treatment Started*])","v":0},{"$f":"COUNTA(PLTreatment[Registration Group])","v":0},{"$f":"COUNTA(PLTreatment[Month 0 Smear Result])","v":0},{"$f":"COUNTA(PLTreatment[Month 0 Date (Smear)])","v":0},{"$f":"COUNTA(PLTreatment[Xpert MTB Result])","v":0},{"$f":"COUNTA(PLTreatment[Xpert RIF Result])","v":0},{"$f":"COUNTA(PLTreatment[Chest X-Ray Suggestive? ])","v":0},{"$f":"COUNTA(PLTreatment[TB Registration No. ])","v":0},{"$f":"COUNTA(PLTreatment[Treatment Outcome])","v":0},{"$f":"COUNTA(PLTreatment[Date of Treatment Outcome*])","v":0},{"$f":"COUNTA(PLTreatment[HIV Status at Beginning of Treatment])","v":9},{"$f":"COUNTA(PLTreatment[On ART?])","v":1},{"$f":"COUNTA(PLTreatment[ART Start Date*])","v":1},{"$f":"COUNTA(PLTreatment[HIV Status at End of Treatment])","v":9}]
[null,"*Date format: dd-mmm-yy (ex. 30-Mar-19)"]

{"sheet":"8a. TPT REGISTER - AGG","index":11,"n_rows":97,"n_cols":23,"rows_kept":97,"cut":false,"hidden":false,"merged":[[68,18,68,22],[66,28,66,34],[68,0,94,0],[37,0,64,0],[68,3,68,4],[68,5,68,6],[68,7,68,8],[68,9,68,12],[68,13,68,17],[6,18,6,22],[6,28,6,34],[37,3,37,4],[37,5,37,6],[37,7,37,8],[37,9,37,12],[37,13,37,17],[37,18,37,22],[36,28,36,34],[6,13,6,17],[6,0,32,0],[6,3,6,4],[6,5,6,6],[6,7,6,8],[6,9,6,12]]}
["TPT REGISTER JOB AID"]
[]
[null,"Instructions: "]
[null,"   1. Gather TPT registers for designated data abstraction period. "]
[null,"   2. Count the page totals for each field and record them here. Each row on this page will represent sums from one page of a register; sections are provided for discrete time periods."]
[]
["Time Period One          ***          Time Period One          ***          Time Period One          ***          Time Period One          ***          Time Period One     ***     Time Period One          ***          Time Period One          ***          Time Period One          ***          Time Period One          ***          Time Period One",null,null,"Sex",null,"Age",null,"Type of Patient",null,"Outcome",null,null,null,"Stopped IPT",null,null,null,null,"Lost to Follow Up"]
[null,"Register Page #","Total Patients ","Female","Male","Age 0-14","Age 15+","PLHIV newly enrolled on into HIV care and treatment","PLHIV on follow-up visit for HIV care and treatment ","IPT Completed","Developed active TB","Died","Transferred out","1. Patient developed symptoms of hepatitis ","2. Patient developed neurological symptoms","3. Patient developed TB","4. Patient not adherent","5. Other (specify) ","1. Client tracked and continued on IPT","2. Client tracked, but stopped IPT","3. Client died","4. Client tracking unsuccessful","5. Other (specify)"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,"Total",{"$f":"SUM(AggTPTP1[[Total Patients ]])","v":0},{"$f":"SUM(AggTPTP1[Female])","v":0},{"$f":"SUM(AggTPTP1[Male])","v":0},{"$f":"SUM(AggTPTP1[Age 0-14])","v":0},{"$f":"SUM(AggTPTP1[Age 15+])","v":0},{"$f":"SUM(AggTPTP1[PLHIV newly enrolled on into HIV care and treatment])","v":0},{"$f":"SUM(AggTPTP1[PLHIV on follow-up visit for HIV care and treatment ])","v":0},{"$f":"SUM(AggTPTP1[IPT Completed])","v":0},{"$f":"SUM(AggTPTP1[Developed active TB])","v":0},{"$f":"SUM(AggTPTP1[Died])","v":0},{"$f":"SUM(AggTPTP1[Transferred out])","v":0},{"$f":"SUM(AggTPTP1[1. Patient developed symptoms of hepatitis ])","v":0},{"$f":"SUM(AggTPTP1[2. Patient developed neurological symptoms])","v":0},{"$f":"SUM(AggTPTP1[3. Patient developed TB])","v":0},{"$f":"SUM(AggTPTP1[4. Patient not adherent])","v":0},{"$f":"SUM(AggTPTP1[5. Other (specify) ])","v":0},{"$f":"SUM(AggTPTP1[1. Client tracked and continued on IPT])","v":0},{"$f":"SUM(AggTPTP1[2. Client tracked, but stopped IPT])","v":0},{"$f":"SUM(AggTPTP1[3. Client died])","v":0},{"$f":"SUM(AggTPTP1[4. Client tracking unsuccessful])","v":0},{"$f":"SUM(AggTPTP1[5. Other (specify)])","v":0}]
[null,"Total",{"$f":"AggTPTP1[[#Totals],[Total Patients ]]","v":0},{"$f":"AggTPTP1[[#Totals],[Female]]","v":0},{"$f":"AggTPTP1[[#Totals],[Male]]","v":0},{"$f":"AggTPTP1[[#Totals],[Age 0-14]]","v":0},{"$f":"AggTPTP1[[#Totals],[Age 15+]]","v":0},{"$f":"AggTPTP1[[#Totals],[PLHIV newly enrolled on into HIV care and treatment]]","v":0},{"$f":"AggTPTP1[[#Totals],[PLHIV on follow-up visit for HIV care and treatment ]]","v":0},{"$f":"AggTPTP1[[#Totals],[IPT Completed]]","v":0},{"$f":"AggTPTP1[[#Totals],[Developed active TB]]","v":0},{"$f":"AggTPTP1[[#Totals],[Died]]","v":0},{"$f":"AggTPTP1[[#Totals],[Transferred out]]","v":0},{"$f":"AggTPTP1[[#Totals],[1. Patient developed symptoms of hepatitis ]]","v":0},{"$f":"AggTPTP1[[#Totals],[2. Patient developed neurological symptoms]]","v":0},{"$f":"AggTPTP1[[#Totals],[3. Patient developed TB]]","v":0},{"$f":"AggTPTP1[[#Totals],[4. Patient not adherent]]","v":0},{"$f":"AggTPTP1[[#Totals],[5. Other (specify) ]]","v":0},{"$f":"AggTPTP1[[#Totals],[1. Client tracked and continued on IPT]]","v":0},{"$f":"AggTPTP1[[#Totals],[2. Client tracked, but stopped IPT]]","v":0},{"$f":"AggTPTP1[[#Totals],[3. Client died]]","v":0},{"$f":"AggTPTP1[[#Totals],[4. Client tracking unsuccessful]]","v":0},{"$f":"AggTPTP1[[#Totals],[5. Other (specify)]]","v":0}]
[]
["top"]
["Time Period Two          ***          Time Period Two          ***          Time Period Two          ***          Time Period Two          ***         Time Period Two     ***     Time Period Two          ***          Time Period Two          ***          Time Period Two          ***          Time Period Two          ***         Time Period Two",null,null,"Sex",null,"Age",null,"Type of Patient",null,"Outcome",null,null,null,"Stopped IPT",null,null,null,null,"Lost to Follow Up"]
[null,"Register Page #","Total Patients ","Female","Male","Age 0-14","Age 15+","PLHIV newly enrolled on into HIV care and treatment","PLHIV on follow-up visit for HIV care and treatment ","IPT Completed","Developed active TB","Died","Transferred out","1. Patient developed symptoms of hepatitis ","2. Patient developed neurological symptoms","3. Patient developed TB","4. Patient not adherent","5. Other (specify) ","1. Client tracked and continued on IPT","2. Client tracked, but stopped IPT","3. Client died","4. Client tracking unsuccessful","5. Other (specify)"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,"Total",{"$f":"SUM(AggTPTP2[[Total Patients ]])","v":0},{"$f":"SUM(AggTPTP2[Female])","v":0},{"$f":"SUM(AggTPTP2[Male])","v":0},{"$f":"SUM(AggTPTP2[Age 0-14])","v":0},{"$f":"SUM(AggTPTP2[Age 15+])","v":0},{"$f":"SUM(AggTPTP2[PLHIV newly enrolled on into HIV care and treatment])","v":0},{"$f":"SUM(AggTPTP2[PLHIV on follow-up visit for HIV care and treatment ])","v":0},{"$f":"SUM(AggTPTP2[IPT Completed])","v":0},{"$f":"SUM(AggTPTP2[Developed active TB])","v":0},{"$f":"SUM(AggTPTP2[Died])","v":0},{"$f":"SUM(AggTPTP2[Transferred out])","v":0},{"$f":"SUM(AggTPTP2[1. Patient developed symptoms of hepatitis ])","v":0},{"$f":"SUM(AggTPTP2[2. Patient developed neurological symptoms])","v":0},{"$f":"SUM(AggTPTP2[3. Patient developed TB])","v":0},{"$f":"SUM(AggTPTP2[4. Patient not adherent])","v":0},{"$f":"SUM(AggTPTP2[5. Other (specify) ])","v":0},{"$f":"SUM(AggTPTP2[1. Client tracked and continued on IPT])","v":0},{"$f":"SUM(AggTPTP2[2. Client tracked, but stopped IPT])","v":0},{"$f":"SUM(AggTPTP2[3. Client died])","v":0},{"$f":"SUM(AggTPTP2[4. Client tracking unsuccessful])","v":0},{"$f":"SUM(AggTPTP2[5. Other (specify)])","v":0}]
[null,"Total",{"$f":"AggTPTP2[[#Totals],[Total Patients ]]","v":0},{"$f":"AggTPTP2[[#Totals],[Female]]","v":0},{"$f":"AggTPTP2[[#Totals],[Male]]","v":0},{"$f":"AggTPTP2[[#Totals],[Age 0-14]]","v":0},{"$f":"AggTPTP2[[#Totals],[Age 15+]]","v":0},{"$f":"AggTPTP2[[#Totals],[PLHIV newly enrolled on into HIV care and treatment]]","v":0},{"$f":"AggTPTP2[[#Totals],[PLHIV on follow-up visit for HIV care and treatment ]]","v":0},{"$f":"AggTPTP2[[#Totals],[IPT Completed]]","v":0},{"$f":"AggTPTP2[[#Totals],[Developed active TB]]","v":0},{"$f":"AggTPTP2[[#Totals],[Died]]","v":0},{"$f":"AggTPTP2[[#Totals],[Transferred out]]","v":0},{"$f":"AggTPTP2[[#Totals],[1. Patient developed symptoms of hepatitis ]]","v":0},{"$f":"AggTPTP2[[#Totals],[2. Patient developed neurological symptoms]]","v":0},{"$f":"AggTPTP2[[#Totals],[3. Patient developed TB]]","v":0},{"$f":"AggTPTP2[[#Totals],[4. Patient not adherent]]","v":0},{"$f":"AggTPTP2[[#Totals],[5. Other (specify) ]]","v":0},{"$f":"AggTPTP2[[#Totals],[1. Client tracked and continued on IPT]]","v":0},{"$f":"AggTPTP2[[#Totals],[2. Client tracked, but stopped IPT]]","v":0},{"$f":"AggTPTP2[[#Totals],[3. Client died]]","v":0},{"$f":"AggTPTP2[[#Totals],[4. Client tracking unsuccessful]]","v":0},{"$f":"AggTPTP2[[#Totals],[5. Other (specify)]]","v":0}]
[]
["top"]
["Time Period Three          ***          Time Period Three         ***         Time Period Three          ***          Time Period Three          ***         Time Period Three     ***     Time Period Three          ***          Time Period Three         ***         Time Period Three          ***          Time Period Three          ***         Time Period Three",null,null,"Sex",null,"Age",null,"Type of Patient",null,"Outcome",null,null,null,"Stopped IPT",null,null,null,null,"Lost to Follow Up"]
[null,"Register Page #","Total Patients ","Female","Male","Age 0-14","Age 15+","PLHIV newly enrolled on into HIV care and treatment","PLHIV on follow-up visit for HIV care and treatment ","IPT Completed","Developed active TB","Died","Transferred out","1. Patient developed symptoms of hepatitis ","2. Patient developed neurological symptoms","3. Patient developed TB","4. Patient not adherent","5. Other (specify) ","1. Client tracked and continued on IPT","2. Client tracked, but stopped IPT","3. Client died","4. Client tracking unsuccessful","5. Other (specify)"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,"Total",{"$f":"SUM(AggTPTP3[[Total Patients ]])","v":0},{"$f":"SUM(AggTPTP3[Female])","v":0},{"$f":"SUM(AggTPTP3[Male])","v":0},{"$f":"SUM(AggTPTP3[Age 0-14])","v":0},{"$f":"SUM(AggTPTP3[Age 15+])","v":0},{"$f":"SUM(AggTPTP3[PLHIV newly enrolled on into HIV care and treatment])","v":0},{"$f":"SUM(AggTPTP3[PLHIV on follow-up visit for HIV care and treatment ])","v":0},{"$f":"SUM(AggTPTP3[IPT Completed])","v":0},{"$f":"SUM(AggTPTP3[Developed active TB])","v":0},{"$f":"SUM(AggTPTP3[Died])","v":0},{"$f":"SUM(AggTPTP3[Transferred out])","v":0},{"$f":"SUM(AggTPTP3[1. Patient developed symptoms of hepatitis ])","v":0},{"$f":"SUM(AggTPTP3[2. Patient developed neurological symptoms])","v":0},{"$f":"SUM(AggTPTP3[3. Patient developed TB])","v":0},{"$f":"SUM(AggTPTP3[4. Patient not adherent])","v":0},{"$f":"SUM(AggTPTP3[5. Other (specify) ])","v":0},{"$f":"SUM(AggTPTP3[1. Client tracked and continued on IPT])","v":0},{"$f":"SUM(AggTPTP3[2. Client tracked, but stopped IPT])","v":0},{"$f":"SUM(AggTPTP3[3. Client died])","v":0},{"$f":"SUM(AggTPTP3[4. Client tracking unsuccessful])","v":0},{"$f":"SUM(AggTPTP3[5. Other (specify)])","v":0}]
[null,"Total",{"$f":"AggTPTP3[[#Totals],[Total Patients ]]","v":0},{"$f":"AggTPTP3[[#Totals],[Female]]","v":0},{"$f":"AggTPTP3[[#Totals],[Male]]","v":0},{"$f":"AggTPTP3[[#Totals],[Age 0-14]]","v":0},{"$f":"AggTPTP3[[#Totals],[Age 15+]]","v":0},{"$f":"AggTPTP3[[#Totals],[PLHIV newly enrolled on into HIV care and treatment]]","v":0},{"$f":"AggTPTP3[[#Totals],[PLHIV on follow-up visit for HIV care and treatment ]]","v":0},{"$f":"AggTPTP3[[#Totals],[IPT Completed]]","v":0},{"$f":"AggTPTP3[[#Totals],[Developed active TB]]","v":0},{"$f":"AggTPTP3[[#Totals],[Died]]","v":0},{"$f":"AggTPTP3[[#Totals],[Transferred out]]","v":0},{"$f":"AggTPTP3[[#Totals],[1. Patient developed symptoms of hepatitis ]]","v":0},{"$f":"AggTPTP3[[#Totals],[2. Patient developed neurological symptoms]]","v":0},{"$f":"AggTPTP3[[#Totals],[3. Patient developed TB]]","v":0},{"$f":"AggTPTP3[[#Totals],[4. Patient not adherent]]","v":0},{"$f":"AggTPTP3[[#Totals],[5. Other (specify) ]]","v":0},{"$f":"AggTPTP3[[#Totals],[1. Client tracked and continued on IPT]]","v":0},{"$f":"AggTPTP3[[#Totals],[2. Client tracked, but stopped IPT]]","v":0},{"$f":"AggTPTP3[[#Totals],[3. Client died]]","v":0},{"$f":"AggTPTP3[[#Totals],[4. Client tracking unsuccessful]]","v":0},{"$f":"AggTPTP3[[#Totals],[5. Other (specify)]]","v":0}]

{"sheet":"8b. TPT REGISTER - PL","index":12,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,1,29,6],[5,1,5,20],[2,1,2,7],[3,1,3,7],[0,1,0,6],[28,1,28,6]]}
[null,"TB TREATMENT REGISTER: PATIENT-LEVEL DATA"]
[]
[null,"Instructions: \n"]
[null,"1. Gather TPT registers for designated data abstraction period and abstract for patients in selected sample."]
[]
[null,"TB TREATMENT REGISTER: PATIENT-LEVEL"]
[null,"PATIENT","Available in TPT Register?","Sex","Age \n(<15, 15+)","Date TPT Started*","New/Existing ART Patient","TPT Outcome ","Reason for stopping TPT","Lost to Follow-up Activities"]
[null,"P1"]
[null,"P2"]
[null,"P3"]
[null,"P4"]
[null,"P5"]
[null,"P6"]
[null,"P7"]
[null,"P8"]
[null,"P9"]
[null,"P10"]
[null,"P11"]
[null,"P12"]
[null,"P13"]
[null,"P14"]
[null,"P15"]
[null,"P16"]
[null,"P17"]
[null,"P18"]
[null,"P19"]
[null,"P20"]
[null,"Complete",{"$f":"COUNTA(PLTPT[Available in TPT Register?])","v":0},{"$f":"COUNTA(PLTPT[Sex])","v":0},{"$f":"COUNTA(PLTPT[Age \n(<15, 15+)])","v":0},{"$f":"COUNTA(PLTPT[Date TPT Started*])","v":0},{"$f":"COUNTA(PLTPT[New/Existing ART Patient])","v":0},{"$f":"COUNTA(PLTPT[[TPT Outcome ]])","v":0},{"$f":"COUNTA(PLTPT[Reason for stopping TPT])","v":0},{"$f":"COUNTA(PLTPT[Lost to Follow-up Activities])","v":0}]
[null,"*Date format: dd-mmm-yy (ex. 30-Mar-19)"]
[null,"Notes: "]

{"sheet":"Hidden Formula","index":13,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date validation "]
[null,{"$f":"TODAY()","v":"2022-09-20"}]
[]
[null,{"$f":"B3-1","v":"2022-09-19"}]
[]
[]
[null,"2020-09-21"]